G
gmazza via AccessMonster.com
Hey there,
I have a form in which I need the navigation buttons to do the following:
Mainform - scroll through every record in the Table 1, with the results
showing up in the subform.
Subform - scroll through the current records in the subform - this is working
automatically for me.
My mainform and subform are based on the same table, Table 1, they just have
different recordsources.
Mainform just bound to Table 1, subform has query with all fields from Table
1, with 2 fields criteria being 2 combo boxes on the main form.
The 2 combo boxes on my mainform are unbound, one grabs a Trademark from
Table 2, the other grabs the Country of the Trademark that exist in Table 2,
not sure if that plays into this.
I linked the Master and Child on the mainform/subform to be Trademark.
When I run the form and choose what I need from the combo's, my subform
displays correctly.
When I navigate to the next record from the main form's navigation buttons,
the subform is not showing Table 1's records.
Note: I did try to make the first combo box on my main form bound to
Trademark from Table 2, however, it was messing with my data when I was
choosing from the combo and displaying to the subform, so I made it unbound
again.
Any help is appreciated. If you need more info please let me know.
Thanks!
I have a form in which I need the navigation buttons to do the following:
Mainform - scroll through every record in the Table 1, with the results
showing up in the subform.
Subform - scroll through the current records in the subform - this is working
automatically for me.
My mainform and subform are based on the same table, Table 1, they just have
different recordsources.
Mainform just bound to Table 1, subform has query with all fields from Table
1, with 2 fields criteria being 2 combo boxes on the main form.
The 2 combo boxes on my mainform are unbound, one grabs a Trademark from
Table 2, the other grabs the Country of the Trademark that exist in Table 2,
not sure if that plays into this.
I linked the Master and Child on the mainform/subform to be Trademark.
When I run the form and choose what I need from the combo's, my subform
displays correctly.
When I navigate to the next record from the main form's navigation buttons,
the subform is not showing Table 1's records.
Note: I did try to make the first combo box on my main form bound to
Trademark from Table 2, however, it was messing with my data when I was
choosing from the combo and displaying to the subform, so I made it unbound
again.
Any help is appreciated. If you need more info please let me know.
Thanks!