Missing controls on forms

  • Thread starter Thread starter Aaron Howe
  • Start date Start date
A

Aaron Howe

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?
 
Aaron Howe said:
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?
Click to expand...

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.
 
Back
Top