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?

I appreciate your help,

George B.

It's impossible to update group queries - they are a summary of existing
data and, as such, cannot be modified in the way you want.  Think about the
situation where you have various bits of data grouped together for the one
side of a one to many, does your update affect the first, last or all of the
records for that data?  Just doesn't work.

Seems like what you need to do is choose between viewing existing info or
adding new data.  In that case you'll need to check the record count of your
query before opening the form.  If >0 then display your current form, if =0
then open a form (based on the underlying record set NOT the group query) to
allow a new record to be added.

Rob