Allow Only One Addition

[Matty]

Hi again,

I'm trying to open a form called SleepStudy from my PatientMain form. I want it to only show a new record so that data can be entered. I've set the DataEntry and AllowAdditions properties of the SleepStudy form to Yes. I took off the navigation buttons but it still allows me to enter a record after the current one (I feed in some data when it opens, so that's probably why it allows me to change records).

Is there any way I can open a form to only show the new record, and not to allow any more new records after that?

 

[Elana]

Set the Cycle property to Current Record.

 

[Matty]

I just tried your suggestion, and no luck.

Once data gets entered in any field of the new record on the form, I'm allowed to go to a next record, go to the last record, or make a new record (all firing my BeforeUpdate event).

When I set the DataEntry property to yes, the previous record button disables (works great). I wish I could set the AllowAdditions property to no to disable the new record button, but I need it to be set to yes so that I can add this one new record.

I think the question I should have asked is: Is there a way do disable future additions while the new record is being made, i.e disabling the next, last and new record buttons?

This form is being opened from a patient-specific main form. It's a form that has the patient's name at the top and actions the patient could take along the side (one being Sleep Study). This patient can only have one Sleep Study record, so that's why want to force only one record.

 

[Matty]

Pat,

If I remove the navigation buttons, the mouse wheel and PageUp/Down keys still can move to that next record. I had looked a long time ago for a way to disable mouse scrolling through records, but everything I found (on this forum and elsewhere online) appeared to be buggy at best.

I was just thinking there must be some way to lock up that form (either through form properties or otherwise), so I don't have to deal with disabling mouse wheels and keystrokes.