Are you are just displaying the file name on the form in an unbound text box or storing that value in a field in your table?

Just a suggestion - You might want to reconsider pulling just the last 12 characters.  That has the potential of creating bad data.  For instance what if you have a shorter file name? Or longer?

I can't remember if Richard covered InStrRev in the String Functions video or not.  I know it is covered in Expert 25.
Also do a search for "Get filename".

It doesn't have to be stored in the database although it currently is but manually entered which is what I was trying to avoid having to do.
I had noticed that sometimes the string was occasionally longer than 12, although most are OK and I would just manually change some if that was a real issue.
I don't remember the InstrRev in the string functions video. I will also do a search for "Get Filename"
Thank you for your advice.

So if I just want to display it in the field on the form and not in the database, how could I achieve that?

See the extended cut for Images

I trust you can read the above - any help would be appreciated.

What do you mean by "automatically" fills in bird name/id? Like when you create a new record in the subform? If so you just need to set the default value on those fields to your Form where the information is, like Forms!FormName!BirdName

Value From a Form and Default Value

Thank you - that has resolved my issue.