Parameter from switchboard to edit record

  • Thread starter Thread starter p-rat
  • Start date Start date
P

p-rat

On the switchboard I have in Access I have the selection of Edit
Record. Once clicked I would like a parameter box to come up and the
user to type in the Record Number. Access would then pull this and
only this record. Once edited she would save and it would go back to
the switchboard for next decision. Is this easy to do? If so, how?
Thanks.
 
You could do this is you had a form that opened as modal where the user
types in the record number.
In code you do it like this:
DoCmd.OpenForm "NameOfForm", , , , ,acDialog
The acDialog bit makes this form open on top and nothing else on the
switchboard works until this modal form is closed.
After the user types in the record number and presses the OK button you use
it to open the edit form and at the same time close the modal form and the
switchboard form.

Jeanette Cunningham
 
Back
Top