Search results for query: *

This SOO cool! I was wondering how to fix this problem - and there was the answer. One limitation, you can only use the zoom values that are in the pull down box of the command - you can't use 80 for example. However, we'll take waht we can. Ray Shillito (Genengineer)

OK - I found out what was causing the missing records. The Combo Box had the Bound column set to 1 when it should have been set to 2 (the column with the data!). So now it works really well. I can use this all over the place. I am posting the ful code here for anyone else to use. the two...

I wrote the thing as... WClause = "[SelectRelations].[Country] = '" & Me.CountryCombo & _ "' AND [SelectRelations].[Event] = '" & Me.EventCombo & "'" And it does not fail, but it returns zero records - i will have to figure that out myself! It was correct...

Thanks for replying. I tried this and got a "data type mismatch in criteria selection" This happens whether I dim Wclause as a string or without the data type. The combo boxes do select from different tables, but the data types are all text and of the same length - unless the combo...

I tried to set up a form where the user could select Country and Event from combo boxes, and then pass the results to a DoCmd.Openreport. I tried all sorts of combinations of formatting and kept getting data mismatches or the openreport would not recognize the input, so I gave up and just used...

I tried to set up a form where the user could select Country and Event from combo boxes, and then pass the results to a DoCmd.Openreport. I tried all sorts of combinations of formatting and kept getting data mismatches or the openreport would not recognize the input, so I gave up and just used...