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
|
|||
|
|||
Missing controls on forms
I have created a form based on a query, which gets data
from two tables (see my post yesterday for further details on that). I use the wizard to do this for simplicity and bind the form to the query I need, then use combo boxes to look up the various pieces of data and store them in the field I need. I know that can't be right, I should be chucking it all in a table. My question: do I use a make-table query or create a whole new table to replicate all of the fields I need? If I use a make-table query can I base a form on it? And why don't my controls show up, even if they have nothing to display within them? |
#2
|
|||
|
|||
"Aaron Howe" wrote in message
... I have created a form based on a query, which gets data from two tables (see my post yesterday for further details on that). I use the wizard to do this for simplicity and bind the form to the query I need, then use combo boxes to look up the various pieces of data and store them in the field I need. I know that can't be right, I should be chucking it all in a table. My question: do I use a make-table query or create a whole new table to replicate all of the fields I need? If I use a make-table query can I base a form on it? And why don't my controls show up, even if they have nothing to display within them? I don't understand most of your question, but I can tell you that the usual reason for no controls being visible is that (1) there is no data in the form's record source, and (2) the form does not allow records to be added. This would normally be because the form's AllowAdditions property is set to No, but in your case, with a form based on a multi-table query, I would hazard a guess that you have created a non-updatable query. As I say, I really don't understand the rest of your description. Why have you created a form based on more than one table? This almost invariably causes a lot of problems, and almost invariably is not necessary. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
My Access front-end bloats! | Rauken | General Discussion | 10 | September 28th, 2004 05:06 AM |
AllowAdditions=False makes unbound controls blank out when recordcount=0. | Jon | Using Forms | 2 | August 21st, 2004 03:08 AM |
Help with report...need to list if any info was missing from application. | Jacqueline | Setting Up & Running Reports | 2 | June 3rd, 2004 01:38 PM |
How to repeat code that is used in all forms | Christine | New Users | 1 | May 20th, 2004 02:18 PM |
Microsoft Forms: Cannot load as some objects are missing from this machine | Graham | Setting up and Configuration | 0 | January 8th, 2004 03:26 PM |