adding a new record with code

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.
 
C

Capn

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

Similar Threads

Clearing combo boxes and a text box 2
Dynamic Naming of Form Button 3
Creating a Search using a combo box and then creating a report. 4
Adding a comment in a footnote area 1
Link a text box based on drop down box with four options MS Word 365 0
Print Form with single record 1
Need help modifying code 0
Audit trail on form 1

Top