Switchboard edit form

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

Guest

We have created a form in Access that we allow edits to the data. In the switchboard, the command is " open form in edit mode. Also, we have created two buttons to look up data on this form.

Is there anyway to display the fields as blank when the user first enters the form, whereby they should do a look up in the table using the two buttons.

We are having issue where the last record displays and the user types over it
Thanks
 
You can set the Record Source for the form to something like

SELECT * FROM MyDataSource WHERE False

and then replace it in the code from the two buttons with

SELECT * FROM MyDataSource WHERE True

This will basically put nothing into the form until the user uses the buttons.

Pavel
 
Back
Top