The data on my report doesn't update when I make a new selection in a combo box

[lukesmith]

I am using MS Access 2003 (I'm on an old pc).

I have a report that takes data from a a table called 'tbl_AirlineCro ssSellingList'
This data is then filtered down based on a selection made in a combo box 'cmb_CrossSelli ngList'.
When the user clicks a button to preview the report the data does not change based on the selection?
the query SQL code reads as follows;

SELECT tbl_AirlineXSL.Airline, tbl_AirlineXSL.[Airport Requesting], tbl_AirlineXSL.[Date Requested]
FROM tbl_AirlineXSL
WHERE (((tbl_AirlineXSL.Airline)=[Forms]![frm_Splashscreen]![cmb_CrossSellingList].[BoundColumn]));

Please can someone tell me how I can make this work?

[jimatqsi]

Tray this. Add

if me.dirty then me.dirty = false

at the top of your preview button click handler.

[Rabbit]

The .BoundColumn property holds the column that is bound, it does not return the value of the column.

[lukesmith]

jimtqsi.... The button uses the macro view in Access rather than the VBA view to run the macro, so I don't know how I would add that in?

Rabit... When I remove the bound column property it says 'The Expression is typed incorrectly or it is too complicated to be evaluated...... .'
The code now reads;

SELECT tbl_AirlineXSL.Airline, tbl_AirlineXSL.[Airport Requesting], tbl_AirlineXSL.[Date Requested]
FROM tbl_AirlineXSL
WHERE (((tbl_AirlineXSL.Airline)=[Forms]![frm_Splashscreen]![cmb_CrossSellingList]));

[zmbd]

lukesmith:

A Few things:

1) Not many of use use Macros, especially pre-2007 as they are very limited in what they can do.

To verify that your control is using a macro:
Please reopen the form in design view.
Right click on the button
In popup please select "properties "
In the properties dialog, please select events tab
In the on click event, please tell us what is there...

If you are truely using a macro, then we may need that code. I have a little ditty I picked up somewhere that will send those to a text file that you can then open and cut and paste back to the thread.

2)

Rabit... When I remove the bound column property it says 'The Expression is

Rabbit did not tell you to REMOVE the bound property.
Rabbit was telling you that the value in the bound property will be the column to whit your control will return the value thereof.
For Example:

SELECT tbl_AirlineXSL.Airline, tbl_AirlineXSL.[Airport Requesting], tbl_AirlineXSL.[Date Requested]

Boundcolumn = 1 returns the value in tbl_AirlineXSL. Airline
Boundcolumn = 2 returns the value in tbl_AirlineXSL.[Airport Requesting]
etc...

thnx