A
Andy G
I've ran into a little problem that I would appreciate some help on. I have
a simple database that keeps track of contacts and their contact
information. The best way to explain this is I want the same functionality
of Outlooks on the contacts page, where you add the address using the drop
down list to say what type of address it is. I want to click on my combo
box (cmbAddressType) to look up the address information and display it in
the address, city, state, and zip fields (txtAddress, txtCity, txtState,
txtZip respectively). I have the combo box bound to the ADDR_TYPE_ID
(record source for combo box is from a table holding 3 types of address and
their single digit key, 1-Home, 2-Business, 3-Summer) field in the record so
when you click on it, Access wants to add a record since it is bound and I
get duplicate primary key errors among others.
In summary: My combo is being used for record look up and
adding/saving/editing and so on...Accomplishing these seperate is fine but
together is a challenge since it is not working out at all. I have decent
experience with VBA, which I know I will need in this case. I want mine to
work just like Outlooks does, just look at that and apply it to my
situation. Thanks everyone!
a simple database that keeps track of contacts and their contact
information. The best way to explain this is I want the same functionality
of Outlooks on the contacts page, where you add the address using the drop
down list to say what type of address it is. I want to click on my combo
box (cmbAddressType) to look up the address information and display it in
the address, city, state, and zip fields (txtAddress, txtCity, txtState,
txtZip respectively). I have the combo box bound to the ADDR_TYPE_ID
(record source for combo box is from a table holding 3 types of address and
their single digit key, 1-Home, 2-Business, 3-Summer) field in the record so
when you click on it, Access wants to add a record since it is bound and I
get duplicate primary key errors among others.
In summary: My combo is being used for record look up and
adding/saving/editing and so on...Accomplishing these seperate is fine but
together is a challenge since it is not working out at all. I have decent
experience with VBA, which I know I will need in this case. I want mine to
work just like Outlooks does, just look at that and apply it to my
situation. Thanks everyone!