I have an access database.
there is a table called leads. one of the records in that field has the name called another field has the name telemarketer.
I have a select query that finds all records in the leads table where field called = no and telemarketer = x.
There is a form based upon this query which shows each record meeting the criteria so that the telemarketer can make there calls.
When I open the form from the switchboard in edit mode I can change the contents of the fields.
However when the telemarketer does so it does not let him edit the contents of the fields.
I thought this might be due to security permissions, so I set the user permissions for another user to be the same as mine on the table, the query and the form, however the issue still occurs.
can anyone help me with what my mistake is?