Display blank record on form entry

  • Thread starter Thread starter Ian Smith
  • Start date Start date
I

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?
 
Ian Smith said:
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?
Click to expand...

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.
 
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
 
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.
 
Back
Top