Multiple check boxes causing form to appear blank

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

Guest

Hello

I am creating a form with fields from a number tables. 3 of these tables
contain checkboxes and another one contains just text fields. If I insert one
table with text fields and one of the tables with the check boxes in them,
using the wizard, the form will work ok. However as soon as I add another
one of these tables (creating a brand new form using the wizard) the form
appears blank in form view with no fields showing whatsoever.

I was hoping not to put these tables into the form as a sub form as I will
need to enter an additional table later on for this.

The other problem that I am having is that I need these 3 tables with
checkboxes to have a ability to allow multiple values entered, for example:

There is a table with weekdays and you check the weekdays that you wish to
be contacted, there is a table with times that you wish to be contacted and
another table with various event that you would like to participate in.

Is there a maximum number of tables with checkbox options that are allowed
to be entered into a form?

Any help with this is greatly appreciated

Stuart
 
a blank form would indicate that there are no records that meet the criteria
you specified. If you run the query (upon which the form is based) do you
get any records? If not, then that is your problem.

Rick B
 
I have realised the problem, i needed a one-to-one relationship for the
tables, not a one-to-many. The form now works
 
Back
Top