Auto file text box

I want info from one form text box to auto fill another form text box when the second box gets the focus.
I tried an Expression did not work and I tried this code
"Me!txtIncidentNumber = Me1Incident.txtIncidentNumber

re: Auto file text box

Have you tried using DLookup?

re: Auto file text box

No but will try this and see what hajppens

re: Auto file text box

I'm not sure exactly, but see if this (Example Filtering on a Form.) will help you.

re: Auto file text box

I assume you mean
"Me!txtIncidentNumber = Me!Incident.txtIncidentNumber".
Is "Me!Incident .txtIncidentNumber" meant to refer to the textbox that has been filled out? If so, I think you will need to change it to as "Me" can only refer to the form from which you are running the code. Both forms would have to be open.
The other option would be if the textboxes txtIncidentNumber on both forms are bound to the same field, you could make sure you save the record on the first form and use Me.Requery on the second form when it is activated to refresh the values.

James