Hello Guru's
The problem I'm having is probably very simple but I haven't used Access for several years and I have hit a stumbling block that I hope someone can clear up for me.
I have a form in which I am searching a Query of several tables via several combo boxes that I select from dropdown to filter underlying query for only that selection.
Then a selection from another cbo to further filter the data etc. etc. This is working fine but I have a button to view a report of filtered data.
In the report one of my fields is displaying column 1 of a 2 column query, but col 1 is an ID num and useless. In the form the text I want is displayed but in the report it displays
the ID field. Can't figure out how to get this to display the text value that is displayed on the form.
Form properties
The field in question is [Brands].[Brand]
It's RowSource = "Select Brands.BrandsID, Brands.Brand FROM Brands"
Bound Column = 1
Column Count = 2
Column Widths = 0;1"
In the Report
RecordSource is same as the forms
The Brand textbox in the reports Control Source = [Brand]
But the report is displaying BrandID value not the [Brand] name
Any help would be appreciated
Wally
In the Report the Brand field is the same as the forms Record Source.