Form Default Values

[McArthurGDM]

Hi All,



I have a form that is bound to a table. You can choose a record on the form given that you choose a specific ID that is tied to the table.

When I open the form, I see the "first" record of the table. This is confusing for people that open up for the form because it's an EDIT RECORDS form. You should be able to choose a specific record to edit from initially blank fields.

How do I make it so that, when you open up for the form, the fields are blank and do not show the first record in the table?

Thanks!

[June7]

Options:

1. set DataEntry property to Yes - only new records can be entered, existing records will not display - or use VBA to open the form in add record only mode

DoCmd.OpenForm "form name", , , , acFormAdd

2. code in form load or open (I forget which is best) event immediately moves to new record row - this makes existing records available for navigating

DoCmd.GoToRecord , , acNewRec