Add data via combo box?

[Chris Watson]

If I have a drop down box with names in, is it possible when I select a name from the list (drop down box) that it will fill in data related to that name into several fields on my form, the data from the names will be on a form that is closed.???
Chris

 

[macca the hacke]

Which form will be closed - the one with the combo box, or the one with the data you wish to pre populate?

 

[Chris Watson]

Hi Macca
The one with the Data will be closed, and Im not sure but I think its a List box not a combo box.

 

[macca the hacke]

OK, as long as the form with the list/combo box on is open, doesn't really matter much.
2 ways round this I can think of - easiest is to build an append query that filters for forms!YourFormName!YourComboBoxName as criteria for name. You can then add this data to whichever table contains the data you wish to update (ie the table behind the other form)
Second way is similar but you would do programatically using recordsets.
I would suggest unless you are experienced with Recordsets then first option will work fine.

 

[Chris Watson]

Thanks Macca
But the form will be closed. To give you some more insite into what Im trying to do is: Form 1 has Drivers details: Name, Vehicle Regestration, Fleet No:, and Payrole No:. once these are filled in they will be saved and the form closed. The next form 2 is a running sheet that will log work done by the driver, but he will have to fill in the running sheet on a regular basis, so im wanting a comboBox or ListBox to fill in the drivers details when sellected rather than having to fill them in every time you use the form.
I was hoping there would be some VBA or code.