Row Source

[zogpound]

my row source is coming from a table with 2 columns. Col 1 is name, Col2 is query_name. I want the combo box to only display 1 column with the name, however I want the query_name returned for an onchange event so a query by the same name will run(from a macro).

My current rowsource code is: SELECT [Partners].[Name] FROM [Partners]

If I change it to this: SELECT Partners.Qry_Name FROM Partners;

The macro and query run correctly, How can I combine the 2?

Thanks, Eric

 

[WayneRyan]

Eric,

The rowsource for your combo should be

"select name, qry_name from partners"

Your combo box should have two columns.

Name is Me.YourCombo.Column(0)
qry_name is Me.YourCombo.Column(1)

You can set the width property on the second
column to 0 to make it invisible.

The bound column will be 1.

Wayne