Hi all,
More rookie questions, sorry! I am trying to configure some combo boxes and
not quite sure how to do it. I am using Access 2002.
Scenario 1 - I have a combo box that I want to show a list when the arrow is
clicked. I have put the choices into the table and those are showing up
fine. I would also like to be able to "add" choices from the combo box
itself and have them stored as a future choice. IE = Part Name, it will
show the part names I have put into the table, but then if I add a new part
to the combo box, it will show the new part on the record and then store it
as a future choice...
Scenario 2 - I have a combo box for Supplier and a text box for Supplier
ID. I want to be able to choose a Supplier from the list and when that
choice is made, the Supplier ID test box will automatically populate with
the corresponding Supplier ID number. It would also be nice to have
Scenario 1 also work so I could add a supplier here, have it stored, and
have the supplier ID number automatically update to a new number for the new
supplier and store in the supplier table.
Not sure if these things can be done or not! :-)
Thanks!
Deb
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar