Find record from combobox data

[Brightspark98]

Hi,
I have the following table

tbl_TraineeReport

which stores data from multiple tables via a form,

frm_TraineeReport

How do I retrieve the information from the table tbl_TraineeReport & repopulate the form frm_TraineeReport dependant on two comboboxes in the header row of the form cbo_TraineeName & cbo_TrainingSection. Both values should be in the same record.

Each combobox has 2 values, (TraineeID, TraineeName) & (SectionID, SectionName).


The ID is stored in the tbl_TraineeReport.

I hope this makes sense, (its been a long day).

Many thanks.

[Brightspark98]

Hi,

Sorry Ive just read the last few entries in the forum & found the answer.

Combobox used to find record via wizard.

Thanks