Display blank record on form entry

[Ian Smith]

When I first open a form, I would like it to behave as if
it was positioned on a blank record until the user selects
a record (the first record in my database gets beat up).

Is there a "best practices" method of doing this?

 

[Rick Brandt]

When I first open a form, I would like it to behave as if
it was positioned on a blank record until the user selects
a record (the first record in my database gets beat up).

Is there a "best practices" method of doing this?

Set the DataEntry property of the form to True. It will open on "Record 1
of 1" with the record position being at a new blank record.

You can also use the form's open event to issues a command to take you to a
new record, but I don't consider that a "best practice" because with large
tables you are dragging a lot of data over the wire needlessly.

 

[Guest]

That struck me as a great suggestion. Unfortunately, it
isn't working with my form. I'll dig into it to figure out
why, then go with the data entry idea.

Thanks

 

[Guest]

Drat--Discovered why it doesn't work.

I have the highly unusual circumstance of a form based on
a non-updateble query. It's got a couple of totals queries
that eliminated some dlookups. The updateing all takes
place in subforms.

Since a non-updateable query and the data entry property
are incompatible, the data entry property gets ignored.
That scraps your other idea to.

Thanks, and I'll go away and find another way.