Creating a button to go to a new form with a new record

[cwebb]

Scenario 1:<br>
I have an &quot;entry&quot; form with buttons on it. I am trying to get one of the buttons to go to a blank form (New Clients) to create a new record in a table. I am using the Business ID as the primary key to identify the businesses/clients. <br>
<br>
Scenario 2:<br>
I have a button on a form (Bus Development) with client information. I want that button to go to a new form for telephone conversations. That form(Client Contact) needs to have the same company as the previous form(Bus Development) but allow me to enter the phone conversation information and store it as a new record. The Client Contact form information is in a different table than the Business Development form. How do I do this? How do I make it save, when I close the form?<br>
<br>
DougP and Elizabeth, thanks for the help on Relating fields in a form.

 

[DougP]

Delete your button and add a new one this time with the Wizard. (make sure the button with a Wand and magic dust is depressed) <br>
If after you add a button it does not pop up the command button wizard dialog box then check your settings.<br>
Also it may not have beeen loaded if you did a basic install<br>
I always do a FULL on everything. (Hardrives are cheap)<br>
<br>
Look in &quot;Categoies&quot; for &quot;Record Operation&quot;, click it <br>
in the &quot;Actions&quot; list click &quot;Add New Record&quot;<br>
<br>
Answer #2<br>
It would be better to add subforms to your main form to show information (details about a &quot;Client Contact&quot<br>
One big reason is Access handles the LINK between the 2 tables automatically with a subform, main form by the Child Master Relationship.<br>
So if you find a client and you want to see Phone calls by them when you pull up ht eclient it automatically LINKS it.<br>
Otherwise I hope you know VBA very well.<br>
It will be too much to write all the steps here.<br>
Practice making a main form and a subform.<br>
you can have at least 2 subforms on one main form.

 

[DiscoDuane]

you can put this on the Click event for a button<br>
DoCmd.GoToRecord acForm, &quot;frmYourFormName&quot;, acNewRec<br>