Vlookup?

[sir_dan_mitchell]

Hi,

I have a really anoying problem that I cant solve!!

I have a table that contains fields on people (Name, Address, and loads of codes etc). I then have my main form, here I want to lookup a person using a combo box (done) and for all the fields from the personnel table to import into the fields in the main form once selected and to store those records then in the main table.

Is this possible

Dan

 

[sir_dan_mitchell]

hmm

Ok,

however i need to enter data through the form. Isnt this impossible if its based on a query? If you can solve this, it should work. Thanks Dan