Basic query Question

[Guest]

K, I want to execute a query using a Like "Criteria" statement and display
the results to a form but I also want to be able to add new records using the
same form. What do I need to do change in the query/form to allow field
entries?

This is a strange one because it works ok on other forms/queries. Just this
one is bad.

cheers

 

[John Spencer (MVP)]

STEP 1 - If you run the query outside the form, can you add or update the
records in the query? If so, then check the form. If not, then you need to
examine the query to see why it is not updatable.

Queries may not be updatable if
They are based on more than one table and the tables don't have primary keys
They are based on more than one table and aren't joined
They use DISTINCT in the SELECT Clause
They use any aggregate function (Sum, Group By)
They are a cross-tab query
They are a UNION query
...

Check the form's properties and may sure that Allow Edits is set to Yes and
Allow Additions is set to Yes.