Inserting MemberID into related tables

[Rob]

I have an Access 2002 ADP. I created forms for my tblMbrInfo table and
tblCurrentFinData. The main member form that is used to
enter data has a button that launches the Current Financial Data form. If
a new member is entered into the database, if i click on Current Fin. Data
form i get blanks and cannot enter or edit this form. After troubleshooting
I realized that the MbrID has to be inserted into the tblCurrentFinData to
allow me to enter data on that form (this makes sense... need a record to go
to). I was thinking of using an INSERT statement but not exactly sure how
to proceed. Does anyone have any ideas on how to resolve issue or can
anyone steer me in the right direction.
I appreciate any help.

thanks
rob

 

[Sylvain Lafontaine]

Use something like this in your click event for the button on the MbrInfo
form:

If (Me.Dirty) Then
DoCmd.RunCommand acCmdSaveRecord
End If

This will save the new member information.

S. L.