Hi There,
Basically I have a form with a Combo box on it, with 20 options. Each option is a field name in table1
I then have a query that needs to take the selected field name and perform a look up
ie:
DLookup("Form![formname]![Combo1]","Table1","ID=" &[ID2])
Im not sure if this is posible, If not can anyone think of a work around?
Thanks
D