stop form going to new record

[leemansiuk]

i wonder if anyone can help with this problem i cant seem to work out.

i have a bound form linked to an orders table, including some required fields. when i use the navigation buttons of the form to scroll thorugh the orders i can get to the end where the form expects you to make a new order. but i have a button to add a new order.

i want to stop the user being able to go past the last record in the orders table. or enable them to get back to the last order. currently if the user goes past the last record (making a new order) there is no way to get back to the last record. using the navigation back button causes errors as the required fields are blank and access tries to save the order, thinking i want to make a new one.

i hope this makes sense.

i have tried setting the Allow Additions setting of the Form to No. but this causes problems when there is no data in the orders table. opening the form produces a blank form, showing no fields or buttons at all.

i would be greatful for any advice, maybe i am doing something fundamentally wrong?

 

[Penmore]

Hi eemansiuk,

I'm a little confused here, are you trying to create a form which will allow the user to review existing orders and add new orders ?? or just add new orders ??

 

[Pat Hartman]

Sounds like you have code in the Current event that is dirtying the record. You should remove it. Depending on what the code is, you might just be able to move it to the form's BeforeInsert event. That way the code won't run until the user has actually typed something in the form and thus dirtied it himself.