A
Andi Lee Davis
Hi,
I have a form which is based on a query.
The query has two tables.
One is a table where the information is stored directly, the other is a Query, which enables the CustomerID to show as a text box and not a ComboBox for searching by customer name.
These are linked by CustomerID.
But now all my fields are locked. I can't update the ones I want.
Can anyone shed some light. As soon as I remove the Query that shows the customer I can then update. Why does it lock the records?
Thanks
Andi
I have a form which is based on a query.
The query has two tables.
One is a table where the information is stored directly, the other is a Query, which enables the CustomerID to show as a text box and not a ComboBox for searching by customer name.
These are linked by CustomerID.
But now all my fields are locked. I can't update the ones I want.
Can anyone shed some light. As soon as I remove the Query that shows the customer I can then update. Why does it lock the records?
Thanks
Andi