Separate identical forms with different record sources?

[bosve73]

Instead of creating 3 separate identical forms with different record/control sources
how can I create a combobox that uses the same form but changes the record source(a table)


depending on selection in combobox?

[isladogs]

Cross posted here with answers https://www.access-programmers.co.uk...d.php?t=300516

Please follow standard forum etiquette if you do crosspost. See this link for more info and why it matters
https://www.excelguru.ca/content.php...-cross-posters

[ranman256]

Yes,
the combo wwould have: label,query
Employees,qsEmps
Clients,qsClients

user picks the label,
then the afterupdate event sets the data source (the query)