Unwanted New Record

[schumarg]

Hi,

Been searching through the forum and can't seem to locate a solution, for what I'm assuming is simple but .......

I have a form that is set to DataEntry, I enter all the data and upon completing the last entry/tab a new record appears. This is fine if I want to complete a new record. However, if I do not want a new record and want to simply close the form, I end up with a new empty record. I tried adding a delete code along with the close cmd, but it deletes the new record and when the form closes it creates a new empty record again.

What I would like to accomplish is to close the form with it accepting what I just entered and not create a new blank record.

Thanks in advance,
Bob

 

[Fizzio]

Do you have some event in your form's code that plugs in a value to a record?

 

[schumarg]

Hi,

Not intentionally, do have the OrderNum field datatype set as AutoNumber. As to the other fields, they're just Text or Date/Time datatypes.

I did some more searching and found the Cycle/Set to Current and tried it. Seems to work, not sure this is the proper way of doing it, but........

Thanks,
Bob

 

[JimJones]

Hi,

I'm not sure about the cycle record property, but this thread is along the lines of what I'm looking for.

I have a form, and a subform within a subform.

When I click on the last record button on the main form and then click the next record button, it goes to the Autonumber field, as it's supposed to. But, I wish to stop all the forms from scrolling on the last data record.

Now I will mention that the main form has an autonumber primary key. Same with the subform. But, the subform inside the subform is not an autonumber field, though it too is primary. I just don't want to change it since 'everything' works.

Any help?

Thanks,
Jim