Editing Query Results

[Muzicmn]

I understand that trying to edit a query from multiple tables will not work as the link to the record is "broken". However, is there a way to filter a table and edit the results in a form view. In other words my table holds data for 42 supervisors. I would like to get a form view of the particular sup that is signed in. I can get the results into a form but the records appear to be locked. The Record lock feature to the form is set to "No Locks".

any ideas would be greatly appreciated

Ricky

 

[KeithG]

You will have to use a query behind the form that contains no links to other tables.