If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form from query of a query
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. |
#2
|
|||
|
|||
Form from query of a query
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" wrote in message ... 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. |
#3
|
|||
|
|||
Form from query of a query
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 "Gordon Padwick" wrote: 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" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Controls disappear from Data Entry form | Paul Ponzelli | Using Forms | 10 | February 26th, 2006 05:51 AM |
Customers- Contracts form problem | GL | Using Forms | 10 | February 7th, 2006 04:05 PM |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |