Query/SQL to display fields of another query/table 1

[netsmurph]

I am trying to figure out how I to create a query that will show the available field names in another query/table. Does anyone know how this can be done.

I have seen an example in another database, where a combo box rowsource is based on a function - but I cannot unpick it as it is doing a load of other things at the same time!

Is this quite an unusual thing?

What I need it for is for a user to be able to associate recordset fields with word bookmark (merge fields).

The user creates the query and then has to select the field for each bookmark.

 

[PHV]

Have a look at the RowSourceType property of the ComboBox object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[netsmurph]

Thanks for that PHV, I really was thinking it was much more involved than that - a star all the same!

Cheers


Andrew