Auto file text box

[DeanO]

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

[zimitry]

Have you tried using DLookup?

[DeanO]

Have you tried using DLookup?

No but will try this and see what hajppens

[NeoPa]

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

[jamjar]

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

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

Forms("Incident")!txtIncidentNumber

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