Option Group Selection with Auto Datasheet change

[mba_110]

Hi Dear,

I am trying to make option chain on Access form that pull the individual tables data based on option selected on form.

for example i have 10 option lets say (Employees, contacts, ID's, Sponsors, Qualifications, payments, Vacations etc) and their is unbound datasheet on form why unbound? because i want when i select option Employees the datasheet should show the tblEmployees records, by the same way if i select contacts then it should show tblContacts data in same datasheet not any other tables data and same for all whenever i change option only that tables data should appear in datasheet.

Any option or advise will be appreciated.

 

[Ranman256]

Use a combo box,not option group.

Option groups must be reprogrammed every time there's a change.
But with combo box, all you do is add a value to the table.

 

[mba_110]

What coding is required in combo box events?

How you will link child and master fields in datasheet?

i need this all options in one combo box value list, do you mean that i have to create 10 combo boxes, sorry but your answer is not clear?