dbTalk Databases Forums  

AfterUpdate, OpenForm popup to enter new record into table attached to subform

comp.database.ms-access comp.database.ms-access


Discuss AfterUpdate, OpenForm popup to enter new record into table attached to subform in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Renee
 
Posts: n/a

Default 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

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.