New records not allowed by query...
Quote:
>Hi, I was wondering if anyone can help me with this problem:
>I have the follwing query for duplicates
>SELECT DISTINCTROW [Edit Query].Company AS [Company Field],
>Count([Edit Query].Company) AS NumberOfDups, [Edit Query].Company,
>[Edit Query].ID
>FROM [Edit Query]
>GROUP BY [Edit Query].Company, [Edit Query].Company, [Edit Query].ID;
>The query is linked to a form, which, when there are no records
>generated by the query, is totally greyed out and does not allow me to
>enter a new record. I need to be able to enter a new record when none
>if found. How do I overcome this?
A Totals query - anything with a Group By - is never, under any
circumstances, going to let you update it. It can't: the "record"
that you see does not correspond to any single record in the table,
but instead to a group of records.
You will need to pop up a form based on a simple select query or on
the table itself.
John W. Vinson[MVP] http://www.WysardOfInfo.Com
