Continuous form with subform/listbox???

K

Katrina

I have a table with names and a table with aliases for those names. On my
form I want to diaplay the name once, then a list of any aliases for that
name. I also need my form to be continuous - show multple names. I have
tried several things to no avail. Is there any way to do this?

Thanks in Advance
Katrina
 
K

kingston via AccessMonster.com

If you're using Access2000 (and above), create a subdatasheet by:
Open main table in design view.
Open table properties dialogue.
Set the Subdatasheet Name to your secondary table.
Set the Link Child and Master Fields (probably an ID of some sort).
Now, whenever you open the main table in datasheet view, there will be a
square with a plus in the middle that will expose all of the sub-records.

If you don't want to use datasheets, create a subform in your main form.
Drop the sub-table into the main form and indicate the linked field. The sub-
form wizard should do the rest.
 
M

Marshall Barton

Katrina said:
I have a table with names and a table with aliases for those names. On my
form I want to diaplay the name once, then a list of any aliases for that
name. I also need my form to be continuous - show multple names. I have
tried several things to no avail. Is there any way to do this?
Click to expand...


Use the Concatenate function at
http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'
to build the list of aliases. This can be done in either in
the forms record source query or in a text box expression.
 
Top