Open form - stay on selected record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I open a form using the following command
DoCmd.OpenForm "Employee", , , "EmployeeID = '" & Me![JobNumber] & "'"

form opens to the correct record.

But you can accidentaly move to a blank record with the scrool button on my
mouse, and with pagedown.

How can I fix to not accidentaly move to a blank record?
 
How can I fix to not accidentaly move to a blank record?
Click to expand...

Set the Allow Additions property of the form to No would be a simple solution
(you will need to make provisions for legitimately adding a record though).

John W. Vinson [MVP]
 
Back
Top