Text boxes auto fill after combo box update

[royalbridge]

I'm an intern at a manufacturing facility. I've never used Access before but I'm willing to learn and appreciate all help!



GOAL: select the IC number from the combo box and have 5 text boxes auto fill.

AS OF NOW: I have a table made for the IC number drop down. The columns represent the fields that need to be auto filled.

WHAT I THINK THE NEXT STEP IS: Making some kind of query to link the combo box entry to the text boxes? Some VBA where the control source is equal to my query? I have tried changing the text box control source to equal columns from my drop down but that did not work.

NOTE: the blue font in the first image represents the text boxes that need to auto fill when I select the IC number from the drop down. The second image is my table from which my combo box is generated. The acronyms are for the two tests on this form. Sorry about the abbreviations in the table header.

[nick404]

Should be able to:
Design view of form select the IC number box, go to events tab in properties, click the (..) in after update
Use this code:

Me.txtType = Me.cboIC.Column(2)
Me.txtSMI = Me.cboIC.Column(3)
Me.txtSMA = Me.cboIC.Column(4)
Me.txtSpan = Me.cboIC.Column(5)
Me.txtMinTemp = Me.cboIC.Column(6)
Me.txtClass = Me.cboIC.Column(7)

the "txt..." means the name of the textbox for each field (type, sma, smi, class, temp , etc)
and cboIC means the name of your combo box for IC Number.

[royalbridge]

Should be able to:
Design view of form select the IC number box, go to events tab in properties, click the (..) in after update
Use this code:

Me.txtType = Me.cboIC.Column(2)
Me.txtSMI = Me.cboIC.Column(3)
Me.txtSMA = Me.cboIC.Column(4)
Me.txtSpan = Me.cboIC.Column(5)
Me.txtMinTemp = Me.cboIC.Column(6)
Me.txtClass = Me.cboIC.Column(7)

the "txt..." means the name of the textbox for each field (type, sma, smi, class, temp , etc)
and cboIC means the name of your combo box for IC Number.

Thank you for the fast response. I had no luck with the VBA although it did not show a compiling error! The fields did not update. Here is my code:

[CJ_London]

Note that Type is a reserved word so using it may result in misleading errors

Rather than using code you could just put

= Me.cboIC.Column(2) in the txtType control controlsource
= Me.cboIC.Column(3) in the txtSMI control controlsource

etc

[royalbridge]

All fields are unbound.. does that matter?

[CJ_London]

that error you are getting is an example of what can happen when you use reserved words - change the field and control name to something else - such as ICType

[royalbridge]

Ajax, I typed "Me.cboIC_NUMBERDD.Column(3)" in the control source for smi and the field says #NAME? in form view

[CJ_London]

sorry - I was just copy and pasting in a rush - you don't need the 'me.' part - and unless you have changed the name of your control, you don't need the 'cboIC_' either

Also check that your combo has the number of columns set to 7

[royalbridge]

Okay thanks. I Changed that but the text box appears empty. I set my column count to 7. when I designed my combo box I only included the IC number. not the other columns

[nick404]

Is your cbo getting its values from a table/query or did you type in the IC numbers by hand as a value list?

[royalbridge]

I got! Thank you so much Ajax!

[June7]

If these textboxes are unbound and you are not saving these values to record, VBA code is not needed. Expression in textbox ControlSource can reference combobox column index, just as shown in the VBA.