adding a new record with code

  • Thread starter Thread starter BRC
  • Start date Start date
B

BRC

Access 97 ,win98SE. I have a form (myform) with a subform(mysf). myform
has a combo box which looks up a client and then displays that client info.
mysf is not visable until a client is selected in the lookup combo box. I
would like to add an "addBtn" command button next to the combo box to add
new client. can anyone tell me what the code would look like to add a new
record. So far i have:
Private Sub ADDBTN_Click()
Me.mySf.Visible = True
'????????????
End Sub
Thanks in advance for any help.
 
Maybe you have a good reason for not using the "On Not in
List" event to add a new client. I'm just mentioning it
in case you haven't looked into it.
 
Back
Top