Tables with checkboxes

[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?

 

[Graham Mandeno]

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

 

[Tim Ferguson]

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.

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.

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