M
mccloud
Dale gave a good answer to my problem... see below
1. Create a form for each of the queries.
2. Create a single subform on your main form.
3. In the click event of each of the buttons, change the subforms source
object to the appropriate form.
This way, you are not limited to as single form, as explained by PC
Datasheet. But also avoids the overhead associated with having three
subforms all loaded, but not visible, as mentioned by ABL.
If the only difference in the queries is how they are filtered (they all
contain the same fields), then you only need one form and one subform
control on your main form to display the query results. If this is the
case, when the user clicks the command button, you should update the row
source for the form that contains your query results, then requery the
subform control.
Can anyone explain the code needed to "update the row source and query the
results in a subform? Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
1. Create a form for each of the queries.
2. Create a single subform on your main form.
3. In the click event of each of the buttons, change the subforms source
object to the appropriate form.
This way, you are not limited to as single form, as explained by PC
Datasheet. But also avoids the overhead associated with having three
subforms all loaded, but not visible, as mentioned by ABL.
If the only difference in the queries is how they are filtered (they all
contain the same fields), then you only need one form and one subform
control on your main form to display the query results. If this is the
case, when the user clicks the command button, you should update the row
source for the form that contains your query results, then requery the
subform control.
Can anyone explain the code needed to "update the row source and query the
results in a subform? Help!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!