Access query returns no results

Question

I have a simple situation that isn't acting simply.

I have 1 table, tblApplications. 1 query, qryApplications. 2 form, fmApplicationSearch and fmApplication.

The fmApplicationSearch form has 3 fields (and a button to open fmApplication),

1. txtAppNumber (text box)
2. cboAppName (combo box), row source = Select [tblApplications].[AppName] from tblApplications
3. cboAppShortName (combo box). row source = Select [tblApplications].[AppShortName] from tblApplications

the qryApplications contains all fields from tblApplications with filters

1. AppNumber - Like [FORMS]![fmApplicationSearch]![txtAppNumber] & "*"
2. AppName - Like [FORMS]![fmApplicationSearch]![cboAppName] & "*"
3. AppShortName - Like [FORMS]![fmApplicationSearch]![cboAppShortName] & "*"

fmApplication uses qryApplication as the record source and has text boxes for all fields which should display the info for the filtered application from fmApplicationSearch form. This only works if I enter the application number in the txtAppNumber field, or leave it blank. If I used either of the 2 combo boxes, no data is returned.

I've got other forms and queries that are much more complex than this but I cannot figure out why this simple one just won't work.

Answer 1

I would delete this post if I could figure out how. I figured out the issue. In the thread, I typed it all out by hand because my work has blocked the forums so I had to submit this on my personal computer. When I went back to the work computer, I realized that my combo boxes were querying appNumber and appName so it was trying to filter on the appNumber instead. Doh!