ACCESS FEED: Re: [MS_AccessPros] Combo Boxes

Sabtu, 16 Juli 2011

Re: [MS_AccessPros] Combo Boxes - Multiple Questions Please

Deb,

For Scenario 1...

Have a look at…
http://www.dataschenk.com/newsletters/Tips/Access_Not_in_List.htm

For Scenario 2...

I think you want the name or ID to show up in a Text Box next to the Combo Box. If so, create an unbound Text Box and use...

If numeric...

=DLookup("FieldFromTableOrQuery", "YourTableOrQuery", "[FieldFromTableOrQuery]=" & Me![FieldFromForm])

If text...

=DLookup("FieldFromTableOrQuery", "YourTable", "[FieldFromTableOrQuery]='" & Me![FieldFromForm] & "'")

AND you can also use the solution for Scenario 1 for Scenario 2.

Thanks,
Gina Whipp
2010 - 2011 Microsoft MVP (Access)

www.regina-whipp.com

From: Deb
Sent: Saturday, July 16, 2011 1:37 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Combo Boxes - Multiple Questions Please

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]

[Non-text portions of this message have been removed]