adding a new record with code



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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question