The relational Combo box i made uses another table. the problem is that when i click on the combo box, the list of data shows up but when clicking on the data in the list, i can't choose any of the things from the table.
just having a brain fog because i've successfully created several combo boxes the same way.
my from is based on a query. in the query i joined NewCasesT and ProfAdminT and chose ref integ (2), just like the other combo box prep.
maybe this will help:
SELECT [ProfAdminT].[ProfAdminID], [ProfAdminT].[ProfAdminName], [ProfAdminT].[ProfAdminAddress], [ProfAdminT].[ProfAdminTIN] FROM ProfAdminT ORDER BY [ProfAdminName];
Any suggestions?
Thanks,
John