Access 2007 List Box Field Selection to Query input
Posted on 2012-09-15
I have a table as follows ....
Report Name Loss Ref Num Claim Num Accident Date
Report1 x na na
Report2 na x na
Report3 na x x
If the report output column applies, it is populated with an 'x', otherwise 'na'. I want to build a list box of the column names (Loss Ref Num, Claim Num, etc.) and if I select 'Loss Ref Num' for example from the listbox, pass the selections to a query as follows:
SELECT [Report Name]
WHERE ((tbl1.[Loss Ref Num])="x");
Struggled with this for a couple of days .... time to ask for help.
Many thanks, mec412