Parameter Query

[AccessUser777 via AccessMonster.com]

Hi All,
Here's what I have:

TABLE1(tbl_MAIN_DISC) with the following fields:
DISC_ID=PK
DATE
USER_ID
USER
DISC_TYPE_ID
DISC_TYPE

TABLE2(tbl_DISC_TYPE) with the following fields:
DISC_TYPE_ID=PK
DISC_TYPE

The relationship I have is a 1 (tbl_DISC_TYPE) to many (tbl_MAIN_DISC).
I created a form with two combo box that populate two txt fields(USER_ID &
DISC_TYPE_ID).

I created a parameter query based on the txt fields from the form and it
works great on pulling that specific USER_ID and DISC_TYPE_ID

Is there a way to use the same form and only select the USER_ID and pull all
related records? In other words disable the DISC_TYPE_ID field so that the
parameter query is only using the USER_ID as the criterion? Is this even
possible? Or is creating two forms that pull two differnt parameter quries
the eaiset way to get this done? Is there a way to group all the
DISC_TYPE_ID into an "all" type?

 

[Dorian]

Well, I'm assuming you currently have a form that shows one record and you
now want a form that shows multiple records. So I dont see how you can use
the same form.
Your design depends on what the users of this system want it to do. Should
you not ask the users what they want? Or are you the user?
Possibly you could have a form with search criteria at the top and a
scrolling list (in a listbox) of matching records at the bottom. You can
change the search criteria and click a button to refresh the search results
list. Then you can click a record in the search results to go to another form
that lists all the details. I use this set-up in many applications I have
designed and it works very well.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

 

[AccessUser777 via AccessMonster.com]

Hi Dorian, thank you for your reply. I should have mentioned that the form
I'm using for the parameter criteria has a button to open a report based on
the parameter query. My intention was to see if there was a way to use only
that form and be able to have the user eiter select a specific "DISC_TYPE" or
view all the "all". Any other ideas? Any help is appreciated. Thanks again.

Well, I'm assuming you currently have a form that shows one record and you
now want a form that shows multiple records. So I dont see how you can use
the same form.
Your design depends on what the users of this system want it to do. Should
you not ask the users what they want? Or are you the user?
Possibly you could have a form with search criteria at the top and a
scrolling list (in a listbox) of matching records at the bottom. You can
change the search criteria and click a button to refresh the search results
list. Then you can click a record in the search results to go to another form
that lists all the details. I use this set-up in many applications I have
designed and it works very well.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".

Hi All,
Here's what I have:

[quoted text clipped - 24 lines]

the eaiset way to get this done? Is there a way to group all the
DISC_TYPE_ID into an "all" type?

 

[edward]

Hi All,
Here's what I have:

TABLE1(tbl_MAIN_DISC) with the following fields:
DISC_ID=PK
DATE
USER_ID
USER
DISC_TYPE_ID
DISC_TYPE
ByHostByHostByHost
TABLE2(tbl_DISC_TYPE) with the following fields:
DISC_TYPE_ID=PK
DISC_TYPE

The relationship I have is a 1 (tbl_DISC_TYPE) to many (tbl_MAIN_DISC).
I created a form with two combo box that populate two txt fields(USER_ID &
DISC_TYPE_ID).

I created a parameter query based on the txt fields from the form and it
works great on pulling that specific USER_ID and DISC_TYPE_ID

Is there a way to use the same form and only select the USER_ID and pull all
related records? In other words disable the DISC_TYPE_ID field so that the
parameter query is only using the USER_ID as the criterion? Is this even
possible? Or is creating two forms that pull two differnt parameter quries
the eaiset way to get this done? Is there a way to group all the
DISC_TYPE_ID into an "all" type?