Close form without saving/creating a record

[loopa1]

Hi all
I have a form which when opened it automatically completes a field and therefore creates a new record.

However, If no other fields are entered in to, I want the user to be able to close the form and for the record to be 'ignored' so that tne next time a record is created, it uses this records ID - is this possible?


Thanks.

 

[Norie]

A new record shouldn't be created when something is entered in a field, even if you do it automatically with code.

It new record will be created when you close the form as that will update the data source.

You should be able to stop a new record being created on close by checking the other fields.

 

[loopa1]

I'm not sure what you mean by 'You should be able to stop a new record being created on close by checking the other fields'.

Because the ClientID is populated automatically (which then inserts the client's name too), a new EpisodeID (primary key - autonumber) is created too.

So When I DoCmd.Close the form, the record is kept in the table linked to the form.

Instead, I'd like the user to be able to choose to either ignore the data they've inserted, or if they haven't entered any data, the record isn't kept in the table and the next time an Episode is added, it uses the lowest possible autonumber instead of incrementing it all the time.

 

[Norie]

What I'm trying to say is that a new record is not created until you close the form.

It's not created when you enter data on the form.

You can see that if you enter data on a form and before you close it open the record source of the form.

The 'new' record won't be there.

Now close both and re-open the record source.

The new record will be there.

 

[loopa1]

Ok, understood.

So how do I stop the data being written to the record source?

 

[loopa1]

Scrap that...I've managed to sort that.

But...it's still incrementing the autonumber, is there a way I can prevent this? It's not a big issue, but I'd just prefer it if my ID's were kept as sequential as possible.

 

[loopa1]

Having read a few posts on the web, it seems you can't do what I want to do with an Autonumber - instead, I'll need to use the autonumber as the field to uniquely represent that record and create my own number field for the 'viewable' record ID which I can make sure is sequential with DMax(....

Thanks.