Form data passed to query

  • Thread starter Thread starter Tom Jones
  • Start date Start date
T

Tom Jones

How do I pass the data that I enter in a form to a query? Specifically
I'm looking at case 2 below.

Questions on building this query are in microsoft.public.access.queries,
in the thread If/then queries & wildcards.

I would like to use the same form to view, modify and search for data.

Thus, if I'm looking at an empty form:
* if I enter information and click "save", it adds a record.
* if I enter information and click "query", it passes that information
to my query and displays the results (in that same form).

Many thanks.
 
use an unbound form then you can do what ever operation you would like.

Ken
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Passing wildcard characters to a query 2
Using an append query in a subform 1
Pass-through query 2
Passing multiple strings from a text box to a select query 3
Form-Entered Parameters for Pass-thru query 1
query value subform 3
Create Form Based on Pass Through Query 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1

Back
Top