Hi All
I have a database that in tblmemberdetails there are a number of fields including Member No, Surname and Name however there's also 1-20, 1-21 and so on.
On a form i have a Combo Box with the field names from tblmemberdetails.
When I select the relevant field in the combobox and press another button (which will be 1-20 on wards) i would like it to return the 'Surname', 'Name' and 'Member No' where the value is True for the field selected in the combobox. Ultimately i would like it in a report however if i can get it working in a query i can then set it up in a report.
Is there a way of doing this?
Thank you in advance.