Button to enter criteria into a Query

[michaelk]

Hello all. I am trying to make a database as easy as possible for interns and temps to able to use, so I have made a a switchboard with some common reports. The queries that these reports are based off off are quite similar. They draw from the same tables. The only difference between them is the criteria of one field. Is there any code I could put behind the buttons of the switchboard that would enter criteria automatically? That way I could eliminate the need to have a different query and different report for each option.

 

[ptaylor-west]

Your answer lies with the setting up of the query, you need it to ask for the info needed on whatever the field is in the query as an example enter in the Criteria for a Field names Students Name:

Like [Enter Students Name] & "*"

When you run the query it will ask you for the students name, enter the first 3 or 4 letters and it should complete the rest ( which is why a wild card is used ) and it will give you the results based on your selection.

By creating a switchboard item to run the query the same thing will happen when you click the selection a box will open asking you to enter the name.

Of course you can apply this to any field just put your own field names in.

HTH

Paul

[This message has been edited by ptaylor-west (edited 09-25-2001).]