X
XrayWhiskey
Here is my question:
How do I create a form or subform where I am able to show all records from a
table with a checkbox which then assigns all of these items to the record
from another table -- all while keeping the form aesthetic and user-friendly?
This is what I have:
tblAgency
-------------
AgencyID
AgencyName
luStateID (lookup)
....
tblStates
------------
StateID
StateName
StateAbbreviation
This is what I want:
I am trying to create a subform for use on a tab. When the user goes to
that tab, there are 51 checkboxes (don't forget D.C.!); one checkbox for each
state. The user assigns the state or states to the agency, then moves on to
the next tab.
O Alaska O Illinois
O Alabama O Indiana
O Arkansas O Kansas
I believe this gives a clear idea of what I am trying to do.
How do I do this? THANK YOU!
How do I create a form or subform where I am able to show all records from a
table with a checkbox which then assigns all of these items to the record
from another table -- all while keeping the form aesthetic and user-friendly?
This is what I have:
tblAgency
-------------
AgencyID
AgencyName
luStateID (lookup)
....
tblStates
------------
StateID
StateName
StateAbbreviation
This is what I want:
I am trying to create a subform for use on a tab. When the user goes to
that tab, there are 51 checkboxes (don't forget D.C.!); one checkbox for each
state. The user assigns the state or states to the agency, then moves on to
the next tab.
O Alaska O Illinois
O Alabama O Indiana
O Arkansas O Kansas
I believe this gives a clear idea of what I am trying to do.
How do I do this? THANK YOU!