Query with form problem

  • Thread starter Thread starter Mike J
  • Start date Start date
M

Mike J

I developed a form with Query1. I then made a copy of
query 1 but deleted one of the tables and then named it
query2. I then went into the form and changed 'Record
Source' to reflect query 2. When I opened the form, the
query won't open with the form and therefore the records
won't show. If I run the query by itself, it opens. Any
ideas why the query won't work with the form? If I goback
to the original one, it works fine.
 
are you getting an error message? and if so, what? are any of fields from
the deleted table bound to controls in the form? is any code running in the
form's OnOpen, OnLoad or OnCurrent event? and if so, what?
 
Also, is the form's Data Entry property set to Yes? If yes, is Query2 an
updatable query? If not, nothing will show on the form in this situation.
 
-----Original Message-----
Also, is the form's Data Entry property set to Yes? If yes, is Query2 an
updatable query? If not, nothing will show on the form in this situation.

--
Ken Snell
<MS ACCESS MVP>

code running in
the


.
There are no errors. If I create a new form with the
Click to expand...
same query2, it works fine. Thanks!
 
Back
Top