start form without data

[picyx]

Hello,
I am very new to Access and am trying to build a database of component parts and assemblies.
I have a form where I can type in the assembly name and pick parts from pick lists. I click the "Add record button and it adds the selected data into a table called FINISHED PARTS. My problem is when I open this form it automatically shows the first part in the FINISHED PARTS table. If I add a new part number then click the Add Record button, it overwrites the first record in the FINISHED PARTS table. If I open the form, then click the Add Record button I can enter a nrew part without overwriting any records in the FINISHED PARTS table and adds the record just as I want. My question is is there any way to open this form without it showing the first record in the FINISHED PARTS table? So I can just start entering data without clicking the Add Record button first.

Thank you


Paul

[ranman256]

Yes, start with a MAIN MENU. (unbound)
on it you can put buttons to take you to the forms/tables you need.

put a NEW button to open your form in DATA ENTRY mode:

docmd.OpenForm "frmNewData",,,,acFormAdd

[June7]

Options:

1. set the form DataEntry property to Yes - this means the form will open to blank new record row and only allow new record entry - will not display existing records - so if you want to see existing records will have to use another form

2. instead of above, use code to open form to new record row - so if you open the form from a button on another form -
DoCmd.OpenForm "form name", , , , acFormAdd
existing records will not be available but one form can serve

3. code opens the form then code in the opening form moves to new record row - this will allow existing records to be available
Docmd.GoToRecord acDataForm, , acNewRec