Re: Create Form Run Query Display in Form

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you,
Im still having a problem. here is what I did, if you could help.
I created a form based on a table that has data in it. I then created a
query based on that form with a command button. I then created a new form
based on that query. The command button is linked to open the second form.

the problem i had was when i opened up my first form, the data was already
in it. I could not add new data. I think i needed a blank form to type in
what i am searching for, but the data for the records were there, also it
wouldnt let me add new records, which is good becuase this is just for
searching, but I could not type in anything to search for.

Please help if you can.

thank you in advance

titan

"John Vinson" wrote:

> On Thu, 21 Jul 2005 08:36:12 -0700, "titan"
> <titan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> >Hi,
> >Im trying to create a form for searching. I want that form to be able to
> >once a button is clicked, run queries on selected fields and return all data
> >associated with those records in a Form View.
> >
> >Please help
> >
> >thanks
>
> Create a Query using the form's fields as criteria: e.g.
>
> =[Forms]![formname]![controlname] OR [Forms]![formname]![controlname]
> IS NULL
>
> on the Criteria line for each field that you want to search.
>
> Create a new Form based on this query displaying the data you want to
> see.
>
> Put a command button on the first form to open the second form (use
> the command button wizard).
>
> John W. Vinson[MVP]
>
.

Quantcast