Open form to add new records

[Cosmo Monkey]

This is probaly a simple thing, but any help would be appreciated. I have a Customers form and would like to install a command button that opens the NewShipment form to Add New Record. I am using Access 2010 and my design so far is;
CustomerTbl


ShipmentTbl
PartTbl
PartTypeTbl
One to Many (CustomerTbl to ShipmentTbl)
One to Many (ShipmentTbl to PartTbl) a shipment will contain many customers
One to Many (PartTble to PartTypeTbl)
My logic is that a customer will have many shipments. Shipments will include multiple customers and many parts. The many parts will be of many types. Now if this confuses you it is ok, I am confused myself. Any helps any one could give a monkey banging away at his keyboard would be appreciated.


Cosmo
So Simple a Monkey could do it, yeah right!

[pbaldy]

If you look in help at the arguments of OpenForm, one of them allows you to open the form in data entry mode.

[Cosmo Monkey]

OK...now to show my ignorance...is this correct? (Obviously not, it isn't working)


Private Sub Command1_Click()
DoCmd.OpenForm "Shipments", acNormal
DoCmd.GoToRecord , , acNewRec
End Sub

Cosmo
still banging at the keyboard

[Cosmo Monkey]

just as I posted that, I realized that through my trials and efforts I had used and deleted a couple command buttons. I was trying to call from a deleted command button. Corrected the Command1_Click() to Command106_Click() and wa la...it works...yes....I have figured 105 ways that didn't work. getting closer to that light bulb. Thanks you sir....
Cosmo
A monkey could do it....with a little help!

[pbaldy]

That's a different method than I had in mind, but would be the one to use if you wanted the user to be able to go back to existing records. Normally I wouldn't open a form to all records though, unless it was small. In any case, I suspect you need to add the arguments to the GoToRecord line that specify the form. More info in help.

[pbaldy]

Ah good, glad you got it working!

[Cosmo Monkey]

Being new here I do not know how to mark this solved. I know other people seem to looking for answer to what seems to be similar request in other forums. I joined this one because there seems to be some bright minds here.
Cosmo

[pbaldy]

The Solved option is under Thread Tools at the top of the thread.