Well, Toptech posted he wanted a simple database. I figured I should try help and make it for him, to help me learn access better. Its going good, but came across a odd problem.
I made a Customer Query. In the Query I put two critieria options to pull from Combo boxes (dropdown) on a Customer Search Form. If I run the query ((From the Query List:Not a command box or Form)), it ask for the parameters, I put in the data. It works. The two parameters it ask for is First and Last name.
But if the Customer Search Form is open, the query just displays blank data.
The data is displayed on a SubForm -as in the form of a Datasheet so that it may pull the data from the query. I did this recently on another database and it works fine.
[Forms]![SearchCustomers]![combo10]
[Forms]![SearchCustomers]![combo12]
this is how I entered the critieria in the Query.
Any Ideas?