Alternate Address

[open a adobe file from a command button]

I have table of names, address, with a form that you can enter that info. I
have another table for alternate address with a 1 to many relationship to the
first table. I want to put a cmdbutton on the form so when clicked it opens
a 2nd form and lets you enter a alternate address for the record you are on
(just the address, city, state, zip, & contact number. I use this code but
it ask for the persons memberid,
[FirstTable]![board_memberid]=[Forms]![frmaltaddress]![board_memberid]

 

[KARL DEWEY]

Left join table1 to table2 on memberid.
Use form/subform with Master/Child link set on memberid.