A
ahearn
I am somewhat new to Access and trying to figure out how to edit data based
on a parameter query. Basically what I have done thus far is create a button
with Switchboard Manager that opens a form in edit mode. The form has its
record source as the parameter query, which is based on two tables, and
promts for someone's last name. I have a Like command as a criteria in the
query so they can only enter a few letters of the last name to narrow down
their search. The matching records are then displayed in the form and the
user can scroll through the records to find the one they want to edit.
Unfortunately, even though the fields are displayed they can not be edited.
Any suggestions on what I can do to make these fields editable or another
method to filter records and have the capability of editing the one that is
selected?
on a parameter query. Basically what I have done thus far is create a button
with Switchboard Manager that opens a form in edit mode. The form has its
record source as the parameter query, which is based on two tables, and
promts for someone's last name. I have a Like command as a criteria in the
query so they can only enter a few letters of the last name to narrow down
their search. The matching records are then displayed in the form and the
user can scroll through the records to find the one they want to edit.
Unfortunately, even though the fields are displayed they can not be edited.
Any suggestions on what I can do to make these fields editable or another
method to filter records and have the capability of editing the one that is
selected?