I'm using an order/entry type of form/subform, and I'm having a
problem designing a 'Next Entry"
button. I'd want to clear all data fields from the Form/Subform, add
a new 'DataNumber' (from a CustomCounter function), and the select a
new client (different from the previous one).
The form/subform has a filter = [Client ID#] = Forms![Form1]![Select
Client], and the form and subform are linked by 'Client ID#'.
The subform has recordsource = SELECT Services.* FROM SERVICES WHERE
(((Services.[Client ID#])=0)); so that subform doesnt open with old
valeus for client.
I've tried setting all fields = Null, and requerying the subform (as
well as requerying the entire form), but I keep getting a problem that
the subform field [Client ID#] is not updating to the new value, and
the form doesn't function properly.
Can anyone explain how to best initialize this form in an efficient
manner, so that it functions properly.
Thanks for your help.
RL
|
