querying based on user input in form 2

[Gerilee]

I am learning Access so if you can help me, please give me some details. I have recently taken 4 different level classes in Access and am now working on my first database. I am converting INFORMIX databases to Access. Currently in INFORMIX, the users are able to query using a form. They can query all records by entering nothing on the form or they can put in values in one or more fields and query the table based on those values. INFORMIX performs this without any extra code written. I am trying to figure out how to accomplish this in Access. I thought that I would have a Query command button on the form that the users could use after they enter data (or no data) in as many fields as they want. I would need to know in what fields the user entered data and select the appropriate data from the table based on that criteria. If they enter no data, I would need to know that, too, and then get all records from the table using no criteria. I am somewhat familiar with SQL but just needed to be pointed in the right direction to get this done. Do I need a query, a macro, or VBA code? How do I check if the user entered data in the field? I have lots of years experience in COBOL programming and some in 4GL so I think that I will be able to pick up fairly easily on VBA, if that's what I need. I have been reading and searching the FAQ's but have not found anything that I can understand.

 

[ZmrAbdulla]

[tt][Forms]![myForm]![myControl] OR [Forms]![myForm]![myControl] Is Null[/tt]
is the normal way to bring all the records if criteria left blank.
Some detailed tutorial availabel here

http://www.fontstuff.com/access/index.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
You may be the boss' pet; but you are still an animal

 

[PHV]

Have a look here:

http://download.microsoft.com/download/access2000/Sample/1.0/WIN98Me/EN-US/Qbf2k.exe

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886