Form Record Source Problem

  • Thread starter Thread starter Max
  • Start date Start date
M

Max

Hello,

I built out a nice form. The problem is I made the
mistake and used a query as the record source. I couldn't
make any entries to the form. When I switched the record
source back to the original table, no records where
found. The query and the table are identical. It seems
that the form doesn't want to let go of the query as the
data source. I switch to the table...nothing. Switch
back to the query, and the data comes back....

Any Ideas of what I need to do to get the form to read the
table?

Best regards,
Max
 
If the query was created outside the report (a stand-alone
query) Your report's text fields may be tied to the
queryname.fieldname. You may have to re-select the source
for each of the text boxes in you report.
Hope this helps.
Fons
 
After you change the datat source to the table, make sure
that the text boxes on the report or form are referring to
the correct source.
Hope this helps.
Fons
 
Back
Top