Help with Running Query from Info keyed in Form

[jgreen]

I need help to figure out how to create a form that includes a place to enter date ranges (A start and an end date: the field name in the table is CrossClampDate), patient name, and case number as a search. I have just taken 3 levels of Access classes and saw an example of this, but we never went into it and from the Properties box for all parts of the form I still can't decipher how it was done.

Basically, I want to run the operations a query goes through by inputing this information in a form.

I have created an actual query that performs this operation, and it works. But I am prompted for each criteria separately in individual pop up boxes. I just need to streamline this operation for the users.

Any help would be GREATLY appreciated!!!

 

[Oyster]

Here's how I do it, but its probably not the best way:

I create a form that will capture and pass the parameters to a query. Included on this form is a button that will launch a form, that will use my query and return the requested information to the user.

If this sounds confusing, I'll try to break it down:

Form number 1:
Form's name: Get_the_date
Field on form: StartDate
Button: event-OpenForm, Form's Name: PatientInformation

Query:
Query's name: Qry_PatientInformation
Create a query that will use the parameters passed by Form number 1:
THis is all the patient information for a particular date
Include, whatever fields you want. But in the query restrict the date to where it = [Forms]![Get_the_date]![StartDate]

Form number 2:
Form name: PatientInformation
This form's record source is your query.

Now, when the user runs Form number 1, supplies the date and hits enter, form number 2 will be retrieved with the only the desired info for a particular date.

Hope this helps. If you find a better way to do this, let me know