G
Gary via AccessMonster.com
Dear all,
In my database, I’ve built a main form called frmVIEW for view and edit each
record, this form is in singular form such that each time it’ll only shows
one record. In each record, it has a Boolean field called “memo” which stores
whether that particular file requires a memo or not. And the problem is here:
I want to use a check box control to link with this “memo” field so that once
the user tick this check box, a customized memo form (already built, named
frmMEMO) will be shown for printing, and then the value of this Boolean field
will be updated. And then, if the user seek another record using the
navigation buttons and the memo check box in that particular record is
already be ticked before, then of coz the frmMEMO won’t be pop-up. Conversely,
if the user un-tick the check box (indicating erase that memo record), that
Boolean field value will be changed. I really donno how to perform the above
functions by using those event procedures in VBA, plz help!
Thanks a lot!!!
Gary
In my database, I’ve built a main form called frmVIEW for view and edit each
record, this form is in singular form such that each time it’ll only shows
one record. In each record, it has a Boolean field called “memo” which stores
whether that particular file requires a memo or not. And the problem is here:
I want to use a check box control to link with this “memo” field so that once
the user tick this check box, a customized memo form (already built, named
frmMEMO) will be shown for printing, and then the value of this Boolean field
will be updated. And then, if the user seek another record using the
navigation buttons and the memo check box in that particular record is
already be ticked before, then of coz the frmMEMO won’t be pop-up. Conversely,
if the user un-tick the check box (indicating erase that memo record), that
Boolean field value will be changed. I really donno how to perform the above
functions by using those event procedures in VBA, plz help!
Thanks a lot!!!
Gary