creating a field name list

[kato68]

Is this possible?

I want to create a combo box that list all the field names of a certain table. The purpose of this is to create a select query where the user can choose what fields are to match up in between two tables one being static and the fields from the other being dynamic to see if there are duplicate records in the two tables. Every user has different field names in a table which has the same name universally.

 

[kato68]

In case anyone ever wants to know the answer to this, its really simple and I feel dumb for not figuring it out before i posted. In the properties menu of the list box you want the field names to be displayed in 'Row Source Type' choose 'Field List' and 'Row Source' the table the fields are from.