If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can't create new record in subform
I have a main form "FmLeads".
It contains a field "Salesman" which has an 'After Change' Event Procedure. The Main form "FmLeads", contains a subform "FmDispoHistory". It displays all historic Salesman changes in continuous form format. It is related to with ONE "FmLeads" record -- MANY "FmDispoHistory" records via an ID field. I need the Salesman 'After Change' Event Procedure on the main form to add a new record to the "FmDispoHistory" subform, and then to assign the value of the "Salesman" field from the main form to the "Salesman" field in the subform. Could someone help me with a few lines of VB code that can do tjhis? Thank You |
Thread Tools | |
Display Modes | |
|
|