Inserting a table into a form

  • Thread starter Thread starter James
  • Start date Start date
J

James

Ok then I would like a table in the form that has values
along the top and down the left hand side..

For Example:

Value 1 Value 2 Value 3 Value 4

SubValue1 tickboxhere tickboxhere tickboxhere
SubValue2 tickboxhere tickboxhere tickboxhere
SubValue3 tickboxhere tickboxhere tickboxhere
SubValue4 tickboxhere tickboxhere tickboxhere

Then when the tickboxes are checked or no checked then
they are saved to the appropriate record.

Does this help any?

I have some fields above and below my table so it will be
inserted as a sub form.

Is this possible?

If so how?

Many Thanks

James
 
Is this possible?
Click to expand...

With difficulty.
If so how?
Click to expand...

You'll need to use an unbound Form as your subform (with no
Recordsource, and using checkboxes/textboxes with no Control Source).
You will then need to write VBA code in an appropriate Form event to
poll through all the checkboxes on the form, writing data to a
Recordset based on the normalized table.
 
Back
Top