Setting up a form with table values

[dromorkid]

I would like to open a form to display the contents of a table. The table is like this

PK = DivisionID

DivisionID DivisionName

1000 General Conditions
2000 Site Work
3000 Concrete

I would like to be able to display the 3 records individually so they can be selected by a check box (instead of having them all in a drop down combo box) or not if they are not being used. So I would like the form to look like this

Select a Division

General Conditions [] check box
Site Work [] check box
Concrete [] check box

The Divisions selected will them be put into another table, relating to Job Information. Is this possible or can it not be done from the same table? Do I have to create a table for each individual Division Name?

 

[gemma-the-husky]

look at a continuous form

to do this, in your division table you will also need a "div_selected" field to indicate whether the division is selected or not. don't just use "selection" or "selected" as the field name as they may be reserved words, and best to avoid

 

[dromorkid]

Thank you very much. Do you know that I had created another table while testing this and included a division_selected field. Ok, I got the continuous form showing what I need thus far. Now to make it function, lol. I will be back. Thank you so much again!