N
Nolene
I have designed a form and on the bottom of the form I want to display a
distribution list. The data for the distribution list is in an Access
database and would have to be filtered depending on two controls in the form.
What control will allow you to display data from a secondary source in a
read-only format?
I have only been able to make this work using a list box, but that's not
really the correct control. One, the list box will not resize to show all the
display (it only adds scroll bars) and it's set up for a user to make a
choice and will print only the selected choice. This is what I have been able
to do:
There are two controls at the top of the form - one called "Property" with
three choices, another called "DocType" with nine choices. My Access database
has fields for Property, DocType, Name and Section. Using the List Box, I was
able to connect the secondary data source and add a filter where if Property
on the form matched Property in the database and DocType matched DocType,
then display Name from the database. I was not able to have it display two
fields (Name and Section) which I would like to do. Ideally, the display
would group by Section and display all names that have that Section, then
display the next Section and names under that (like an Access report).
One of the posts said that if you connect your secondary data source, the
fields show up on your Data Souce view and you can just drag the fields into
a control. On mine the secondary data doesn't show up. If I try to insert a
repeating table, I don't get the option to connect to the data source.
How can I do what I want to do?
distribution list. The data for the distribution list is in an Access
database and would have to be filtered depending on two controls in the form.
What control will allow you to display data from a secondary source in a
read-only format?
I have only been able to make this work using a list box, but that's not
really the correct control. One, the list box will not resize to show all the
display (it only adds scroll bars) and it's set up for a user to make a
choice and will print only the selected choice. This is what I have been able
to do:
There are two controls at the top of the form - one called "Property" with
three choices, another called "DocType" with nine choices. My Access database
has fields for Property, DocType, Name and Section. Using the List Box, I was
able to connect the secondary data source and add a filter where if Property
on the form matched Property in the database and DocType matched DocType,
then display Name from the database. I was not able to have it display two
fields (Name and Section) which I would like to do. Ideally, the display
would group by Section and display all names that have that Section, then
display the next Section and names under that (like an Access report).
One of the posts said that if you connect your secondary data source, the
fields show up on your Data Souce view and you can just drag the fields into
a control. On mine the secondary data doesn't show up. If I try to insert a
repeating table, I don't get the option to connect to the data source.
How can I do what I want to do?