AfterUpdate, OpenForm popup to enter new record into table attached to subform -
07-12-2004
, 11:04 AM
OK - need some help here, newbie, haven't done this before and
reaching a deadline really quickly!!
Would like to do the following:
In my main form, I have a Combo box that has different status'. When
you update the status, I want a popup form to open to enter a note
detailing what has happened since the last update. (something like,
the popup opens up, you enter the details and click 'save' to save the
information, then close to close the popup). There is a subform in my
main form which displays all this information. I do not want anyone to
be able to access or change this information in the subform.
I have two tables, one with all the company information, status etc,
and a lead number that my main form is based on.
The second table my subform is based on, and has all the notes saved
for each lead, referenced by the lead number.
I hope I'm explaining this well, and I hope someone can help!!!!
Thanks in advance |