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 or changes 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
 
Max said:
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 or changes 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?
Click to expand...

Did the query alter the field names? If not you should see little
difference. A form can certainly be editable when bound to a query. You
just constructed your query in a way that made it read-only. Did you use
any GroupBy in the query.
 
Nope,

Nothing changed at all. I simple put all fields from the
table into the query. The query does however have fields
from two tables. The form uses only those fields from one
table...Nothing special about the form either.
 
Nope,

Nothing changed at all. I simple put all fields from the
table into the query. The query does however have fields
from two tables. The form uses only those fields from one
table...Nothing special about the form either.
Click to expand...

Ahh... multi-table queries are often rendered non-editable. There is a
help file topic that discusses this that you should check out. You might
be able to modify the query to solve the problem.
 
Back
Top