Tables with checkboxes

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

Guest

I currently have a table with nothing but checkboxes which
correspond to different field names

ie. Letter sent
yes/no
there are currently 72 rows to correspond to business
numbers that are currently in our database. I have then
created a form from this table. What I would like to do
now is have a different form open up the form for the
permit number that matches the permit number that is on
the form I created from the table. Is this possible?
 
I'm not sure I understand your question, but here is a stab in the dark :-)

If you have a form open with a field (say PermitNumber), then you can add a
command button to open another form showing the record corresponding to that
PermitNumber value.

In the Click event procedure of the command button, put some code similar to
this:

DoCmd.OpenForm "name of other form", _
WhereCondition:="[PermitNumber]=" & Me.permitNumber
 
I currently have a table with nothing but checkboxes which
correspond to different field names

there are currently 72 rows to correspond to business
numbers that are currently in our database.
Click to expand...

Really bad idea. Try normalising this set up: I would anticipate a table
with 72 rows of data, each with a single yes/no answer.
What I would like to do
now is have a different form open up the form for the
permit number that matches the permit number that is on
the form I created from the table.
Click to expand...

I don't know what this means, but I bet it's easy once you have a decent
table design.

Hope that helps


Tim F
 
Back
Top