Using a form to create a query

  • Thread starter Thread starter str8actingboi
  • Start date Start date
S

str8actingboi

I have an Access form that I enter data into but I want to be able to
launch a query of the data relating to the data that matches a
particular field (sessionID).

I am able to launch a query to show the data relating to all the
sessions but I want to be able to show a specific session's data by
pressing a launch query button.

I am thinking that I need to put some code in the criteria section of
my query design but not sure what this is. Any help would be great.

Thanks.
 
I have an Access form that I enter data into but I want to be able to
launch a query of the data relating to the data that matches a
particular field (sessionID).

I am able to launch a query to show the data relating to all the
sessions but I want to be able to show a specific session's data by
pressing a launch query button.

I am thinking that I need to put some code in the criteria section of
my query design but not sure what this is. Any help would be great.

Thanks.
Click to expand...

Forms!YourFormName!YourFieldName

Note that a subform may well be all you need and you save all the work of
pushing a button.
 
I have an Access form that I enter data into but I want to be able to
launch a query of the data relating to the data that matches a
particular field (sessionID).

I am able to launch a query to show the data relating to all the
sessions but I want to be able to show a specific session's data by
pressing a launch query button.

I am thinking that I need to put some code in the criteria section of
my query design but not sure what this is. Any help would be great.

Thanks.
Click to expand...

As Mike suggests, a Subform using SessionID as the master/child link field
might be a better choice. Query (or table) datasheets really are not designed
or appropriate for data interaction; a Form gives more control and more
flexibility.

If you need the screenspace you can put the subform on the second page of a
Tab Control (and other textboxes and such on the first page).
 
Back
Top