Query is not pulling values from txt field on form when i click the button

[willmafingerdo]

Hello,


I have a button that runs a query and pulls the criteria form a date field and a dropdown menu field on my form and saves an excel spreadsheet. It will work fine then all of a sudden it will start pulling random values, or only pull like 1 field from the report instead of the full report.. If i go into the query itself and run it w/ the values selected on the form it works, but using the button seems to cause the issue. This is the code in my query to pull the data from the form.

[Forms]![frm_WIGI_Search]![90_Day_WIGI_Date_Txt]
[Forms]![frm_WIGI_Search]![90 Day WIGI AO_Code_Txt]

I dont get any errors or anything, it just stops working.. any ideas please?

[Micron]

If you're saying that with the form open and valid values entered, you run the query and it is fine, but if you THEN click to open the report (i.e. you don't close the form or do anything else) and it isn't fine, then perhaps the issue is in the button code. Maybe post that code - please use code tags (# on posting toolbar) with indentation in the code.
Code also be something about the report and it's code if there is any (e.g. a filter being applied sometimes).

[ranman256]

sometimes i get it to show if i convert it to string:
Str([Forms]![frm_WIGI_Search]![90_Day_WIGI_Date_Txt])