Table/Form Checkbox

G

Guest

Is there a way I can have a checkbox on a form that saves in a table and versa?

Example: I have aform with all the associates info (New Associates) there
are 2 checkboxes (from Pool) and (outside). All information entered in the
form is saved in a table (Associates). Now when I open another form
(Associate Information) I want the same checkboxes to be checked on that form
as it is pulling data from the Associates table. How would I set this up?

Thanks
 
S

storrboy

Is there a way I can have a checkbox on a form that saves in a table and versa?

Example: I have aform with all the associates info (New Associates) there
are 2 checkboxes (from Pool) and (outside). All information entered in the
form is saved in a table (Associates). Now when I open another form
(Associate Information) I want the same checkboxes to be checked on that form
as it is pulling data from the Associates table. How would I set this up?

Thanks


If they are physically two different forms, just set the controlsource
of the checkboxes to the appropriate field (must exist in the forms
recordsource).
 
G

Guest

In your (Associates) table create fields for (from Pool) and (outside). Set
the Data Type to "Yes/No". These fields will appear in the data table view
as check boxes. When you create the (Associate Information) form, just
include these two fields. They will appear on the form as check boxes. Any
boxes checked in the (New Associates) form will also be checked in the
(Associate Information) form because they are based on the same underlying
table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top