#Name? problem

[faz88]

I have a query to show availability of a booking. When i run the query, it works fine. On my form i am trying to create a listbox using the same query. But when the listbox wizard shows the result , all the fields appear as #name?. how do i get it to show the query data instead.

 

[RuralGuy]

Did you set the RowSource of your ListBox to your query?

 

[faz88]

Did you set the RowSource of your ListBox to your query?

The rowsource is set...

 

[RuralGuy]

What is the SQL for your query?

 

[MSAccessRookie]

The rowsource is set...

If the RowSource is set the way that you want it, then try looking for a spelling error in the bound column name for any field with an error. The message usually indicates that either the RecordSource is wrong, or the bound column does not exist in the query or table associated with the RecordSource.