Auto complete

[Stevied]

I have a table witch hold a reference number in one field, house number in another and street in another field. I need to create a form that when the refernce number is entered by the operator the house number and street are automatically entered in the other fields. I'm not sure how to go about it can any one help.

Steve

 

[Ascaphus]

You could use the afterupdate (or similar) event of the ReferenceNo control, and have it update the other two after you enter or choose the reference number. Is that what you meant?

Matt