field that autopopulates in datasheet form

[wrightie]

Hi

Is there any way that I can get a field (Name) to autopopulate once the user has entered data into the AcNo field?

What I have is 2 forms, MainForm and EntryForm which is a datasheet and 2 tables, EntryTable which is empty and NameTable which has two fields AcNo and Name and is populated with all the relevant numbers and names.

I'd like the user to be able to enter data directly into the EntryTable using the EntryForm and when the user enters the AcNo I'd like the Name to autopopulate with the relevant name from the NameTable.

I hope this makes sense!!

Cheers
Wrightie

 

[James Dudden]

You should be able to do this using DLookup do a search and see how you get on.

 

[wrightie]

Hi James ,

Would I need to use DLookup in the controlsource ?

Thanks for you help
Wrightie