T
Trentk
Ok, I have a db that tracks players in a youth sports organization. Family,
Parent & Address info is also in the db in separate tables. I am trying to
set up forms so that the person who mainly uses the db can easily enter new
data without havining to look up the next available ID's.
I am able to to automaically get the next player ID without a problem. It
loads into the proper field automatically on my Add New Player Form. Each
player also has a Family ID (FAMID). Each Family ID is unique by Address.
I have a command button on my Add New Player Form that opens up a read only
address form. This is used to see if the Player's Address is already in the
system by using the search box at the bottom of the form. If the address
isn't located, I have a button that opens an Add New Address Form, the ID for
the New Address loads automatically into this form. The problem is, when
after adding a new address, I am unable to pass the new FAMID to the Add New
Player Form. I am actually unable to pass an existing FAMID to the Add New
Player Form either. The FAMID comes up Null. I am trying to pass FAMID from
one form to FAMID on a subform.
Sorry for the novel, any help appreciated.
Parent & Address info is also in the db in separate tables. I am trying to
set up forms so that the person who mainly uses the db can easily enter new
data without havining to look up the next available ID's.
I am able to to automaically get the next player ID without a problem. It
loads into the proper field automatically on my Add New Player Form. Each
player also has a Family ID (FAMID). Each Family ID is unique by Address.
I have a command button on my Add New Player Form that opens up a read only
address form. This is used to see if the Player's Address is already in the
system by using the search box at the bottom of the form. If the address
isn't located, I have a button that opens an Add New Address Form, the ID for
the New Address loads automatically into this form. The problem is, when
after adding a new address, I am unable to pass the new FAMID to the Add New
Player Form. I am actually unable to pass an existing FAMID to the Add New
Player Form either. The FAMID comes up Null. I am trying to pass FAMID from
one form to FAMID on a subform.
Sorry for the novel, any help appreciated.