I have a database for a small city grass roots organization. I have a
list of block captains, there information is entered thru a form. Each
of these block caps will bring in their contacts and we enter the list
into table thru form. So far fine...I created a second form tied to
same table for this, the next layer of contacts, (block caps
contacts.) What I want to do is have the second form, when called,
automatically append the block captains name in the block captain
field of the second form as the info is entered. Sure I could manually
type it or create a drop down with nearly 100 names! But I am sure
this can be done. What I am asking to do is automatically fill in the
Block Captain name when the end user clicks to enter Block captains
contacts from the main form! Please help me!