Blocking a 'next record' action on a form

[jonwebb]

Hi,

Hope someone can help. I'm building a form to allow users to enter data and want them to be able to scroll through records adding and reviewing data. When they want to add new data, they go to the last/new record button and add it there. However, if they are reviewing and go to the new record, they can't actually go back because it would violate the primary key (certain fields are auto populated, making up a partial key on the table).

Is there any way of using the navigation buttons to only go from the first to last existing records, whilst having it in edit mode? I then want to give them a button to add a new record which I've figured out how to do. If they add a new record by mistake that's their own problem!

Thanks in advance,
Jon

 

[Corticus]

You can set the form properties (manually and through code) for 'AllowAdditions' to false, this will prevent adding new records.

Your button to add a new record (I imagine you're using docmd.gotorecord,,acNewRecord) should also set 'AllowAdditions' to true.

To help avoid the annoying key messages, you can use the form_before update event to test for the current record to be 'dirty', which means they are in the middle of entering data, but haven't left the record yet.
Code:
If me.dirty then .....
You can them prompt them to enter specific information. You could also ask them if they want to exit the record without saving, if so, using:
Me.Undo (which is the same as hitting ESC)
will back them out of the current 'dirty' record.

 

[jonwebb]

Fantastic, solved all my problems. Thank you very much!

Jon