ComboBox How do I Autofil/autopopulatel text fields with selection of combo box

[sonickidj]

Hi there, i'm quite a newbie at Access and i am currently stuck on a form problem. I am using a wizard of oz-style database and I want to autofill boxes through the selection in a combo box



I already have fields in my database including charactersname, characters gender, characteridnumber etc.. and i want to include the charactersname in the combo box, so that when selecting a name, the appropriate gender is also shown below that

In other words, if Dorothy was on the selection list/box, when selected, the gender field at the side would automatically turn to "Female", same goes for Tinman and Scarecrow being "Male"

Thank you very much :-)

[pbaldy]

Like this?

BaldyWeb - Autofill

[John_G]

Hi -

Does the Characters table have an ID number or other unique short field as the primary key? If not, it should, because using a character-string as your PK is (or can be) cumbersome at times, and in the case of people's names, is prone to problems with duplication.


Now to answer your question - what you would need is some code in the after update event of the combo box, to retrieve values from the characters table and copy it to the form text boxes. The DLookup function is best used for that, and it looks something like this:

Me![Control_Name] = DLookup("Lookup_Field","Characters","Character_ID = " & Me!ComboBox_Value)

The names in italics would be replaced by the names you actually use in your database.

You would use one DLookup for each form text box.

Are the text boxes you want to fill on the form bound to table fields? They really should not be, because that results in redundant data.

HTH

John

P.S. I didn't see it before posting, but the suggestion from pbaldy works just as well, and might be easier to use.