Can't enter info into query

[JSD]

For some reason the query I built will not let me enter any info into it. Is this a relationship problem or because I am using the querie in a form that has subforms, (I can enter new info into the subforms.) or because I wrote code to just print the report to the current record? Or something else????

Thanks!
Julie

 

[TanisAgain]

Post the SQL

 

[Matt Greatorex]

This may or may not help

http://www.access-programmers.co.uk/forums/showthread.php?t=105404&highlight=updateable+query

 

[JSD]

Sql

Hi,

Here is the SQL from the query.

SELECT DISTINCT Contact_Information.Contact_ID, Contact_Information.[Active?], Contact_Information.[Last Name], Contact_Information.[First Name], Contact_Information.Spouse, Contact_Information.Address, Contact_Information.City, Contact_Information.State, Contact_Information.Zip, Contact_Information.Email, Contact_Information.CellPhone, Contact_Information.[MEMO FOR SS LETTER], Contact_Information.MemoBox
FROM Contact_Information;

 

[Pat Hartman]

Distinct, aggregates rows. That is what is making the query not updatable.

 

[JSD]

Yipee!

Thanks! Now the query updates!

When I went to the form that pulls from that query, everything is blank. I can add contacts but it doesn't see the original contacts that were there. Any Idea why it is not seeing the original contacts? I can re-enter them, but would rather not.

Thanks so VERY MUCH!!

 

[JSD]

oh, no

I just noticed when I closed the form and reopened it, the test info I typed in was gone. It is in the query, but the query is not flowing into the form. yikes. What am I missing here? Thanks!

 

[JSD]

nevermind

The data entry was set to yes, so it was just opening a blank form. Thanks!