Form from query of a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a query that links two tables and creating a form from this query with
a combo box works fine, but now I want to add another table containg recods
to this query and I have joined one field to the first query(2 tables made
into a query), this works fine also, but now when i go back to the form, and
add the extra fields to the form from the 3rd table that was created in the
query, the combo box no longer works properly!! what am i doing wrong, thanks.
 
You really don't provide enough information for me to provide an adequate
answer..

You say the "combo box no longer works properly." In what way doesn't it
work properly? What doesn't it do that you intend?

If you can describe in more detail what you are doing and what you intend to
achieve, I can probably help.

Gordon

Debba said:
I have a query that links two tables and creating a form from this query with
a combo box works fine, but now I want to add another table containg recods
to this query and I have joined one field to the first query(2 tables made
into a query), this works fine also, but now when i go back to the form, and
add the extra fields to the form from the 3rd table that was created in the
query, the combo box no longer works properly!! what am i doing wrong,
Click to expand...
thanks.
 
Sorry. Ok i have since been reading other stories on here and it looks to me
like I have made an unupdateable query. The combo box opens but i just get a
beep when trying to select an item and nothing on the form updates! Im trying
to update from this query using a form, the query is of another query and
when i run the query, the results are what i want, ii just cant add or update
anything. thanks anyway
 
Back
Top