Is it possible to open a form to a blank record?

[Seth Schrock]

Currently I have inserted blank records with record IDs of 99999 and just linked the "open form" button to the last record, but I would like to be able to open it to just a blank record if I was just opening the form. Is this possible? My boss is asking and I don't know.

[NeoPa]

When you say blank record, I assume you mean a new, unsaved, record. As if you clicked on the New button of the Record Navigation buttons. It is possible to navigate to any record when you open a form.

It is also possible to set the form so that only new records can be processed (You wouldn't be able to edit an existing record at all) by setting the .DataEntry property to True.

[Seth Schrock]

I was more meaning just a blank record. My problem is that my primary key is an auto-number, so the new record has a "(new)" inserted automatically. I was hoping to get around this is possible.

[NeoPa]

I'm not sure what you think you're saying Seth, but I can't make it make sense. If a table has an AutoNumber field then it's not even conceivable (what sense would it make anyway?) to have a blank record with no value for this field.

[Seth Schrock]

I don't need the table to contain a blank record, but I just need the form to be blank. It would probably have to be done by opening the form to no record. Does that make sense? Again, I'm not sure if it is possible. I'm just asking so that I can tell my boss.

[Mihail]

You can hide the text box where your AutoNumber is displayed. Anyway you can't make any change in that field. Or play around formats: If current record is a NEW record, set paper color and ink color to the same value, else set colors as you need (i.e paper=white, ink=black).

[NeoPa]

Seth:
Does that make sense?

You cannot go to a blank record Seth. As Mihail says, you can do various things to hide it, but essentially the concept of a blank record in these circumstances doesn't make sense, no.

[Seth Schrock]

Okay. I'll see if going to a new record will satisfy my boss. At least I can now tell him for sure that it isn't possible to do anything else.

Thanks everyone.

[Rabbit]

As Mihail said, why not just hide the autonumber field?