Search results

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

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!

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...

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...

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...