Retreaving data from different table

[KingDavid]

Okay I've done this a hundred times but for some reason I'm having a HUGE brain fart!!

I have two tables, in a simple form I want to populate the fields of the first table, and then have a simple drop down box that u can select a field from the second table and then it will populate all the fields from the second table to the second table, leaving the second table without any changes.

Sorry for the stupid question but I've been working on it for quite sometime and simply can't get it to work gotta be sumfing really stupid I'm doing.

 

[LittleSmudge]

I assume you mean select a RECORD from the second table .. ..


So bind the form to the first table.

Then in the After_Update event in the combo box you open a recordset on the second table using the data from the combo box to select the appropriate record

Then populate the controls based on the values in the recordset.


'ope-that-'elps

G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.