D
dcc15 via AccessMonster.com
Hi everyone,
I am stepping into sub-forms (Finally). I am creating a form to perform
administrative functions (Verifying/closing records) on my DB. What I need
some help on, is filtering the records for editing (in the sub-forms), I'd
like to have one (maybe two) TextBox/Controls where I can enter a Record ID
(I have two tables the same ID as FK's) and have the sub-forms filtered for
only the records with the ID entered. Here’s what I have come up with so far,
for an unbound control on the main form to get what I want on the two sub
forms (seems to be doing the trick for this part):
Private Sub NcNumSearch_AfterUpdate()
Me.[F_CA_AdminSub].Form.Filter = "([NcNum] = '" & Me!NcNumSearch & "')"
Me.[F_CA_AdminSub].Form.FilterOn = True
Me.[F_RMA_AdminSub].Form.Filter = "([NcNum] = '" & Me!NcNumSearch & "')"
Me.[F_RMA_AdminSub].Form.FilterOn = True
End Sub
What I'd like to be able to do on top of this, is add the ability to double
click on the ID of either sub-form (Datasheet view) to open a corresponding
form, in that record for editing (subforms only contain minimal fields for
closing records that I (or another user) Know the details are complete
(records have several large text/memo fields). I've seen this in an "example"
somewhere but can't seem to find now. Any help on doing this would be
appreciated.
Thanks
DCC
I am stepping into sub-forms (Finally). I am creating a form to perform
administrative functions (Verifying/closing records) on my DB. What I need
some help on, is filtering the records for editing (in the sub-forms), I'd
like to have one (maybe two) TextBox/Controls where I can enter a Record ID
(I have two tables the same ID as FK's) and have the sub-forms filtered for
only the records with the ID entered. Here’s what I have come up with so far,
for an unbound control on the main form to get what I want on the two sub
forms (seems to be doing the trick for this part):
Private Sub NcNumSearch_AfterUpdate()
Me.[F_CA_AdminSub].Form.Filter = "([NcNum] = '" & Me!NcNumSearch & "')"
Me.[F_CA_AdminSub].Form.FilterOn = True
Me.[F_RMA_AdminSub].Form.Filter = "([NcNum] = '" & Me!NcNumSearch & "')"
Me.[F_RMA_AdminSub].Form.FilterOn = True
End Sub
What I'd like to be able to do on top of this, is add the ability to double
click on the ID of either sub-form (Datasheet view) to open a corresponding
form, in that record for editing (subforms only contain minimal fields for
closing records that I (or another user) Know the details are complete
(records have several large text/memo fields). I've seen this in an "example"
somewhere but can't seem to find now. Any help on doing this would be
appreciated.
Thanks
DCC