Text box based off combo box selection

[thedeadzeds]

Text box based off combo box selection

Hi All,

I’m trying to auto populate the text boxes in the form based on drop down from the combo box. As you can see in the form Frm_Input, this works fine for FL, but for some reason it will not populate for Skill, Role, FLM and Location. The table it is linking to is Tbl_Names. I cannot for the life of me figure out why as I have changed the column source?

Regards

 

[pbaldy]

Can't look at the sample right now, but make sure the column count property of the combo is correct. It should be the number of fields in the row source.

 

[thedeadzeds]

Hi, yep count of the combo box looks ok I think

 

[pbaldy]

No, it's not...

 

[thedeadzeds]

ok, thanks for that. I'm a little confused as I can't see where I am going wrong, would something be able to help?

Many thanks

 

[JHB]

Open the form in design view, mark the control "Combo89", set the "Column Count" property to 5, set the "Column Widths" property to 4cm;0cm;0cm;0cm;0cm.
Database attached.

 

[thedeadzeds]

Perfect, makes complete sense now.

Thanks again

 

[thedeadzeds]

Sorry to come back on this, just one last questions. How do I know get the auto populated info in the form to feed into the table?, ie, skill on the form to feed into skill on the table?

Many thanks

 

[pbaldy]

The second method, though it typically shouldn't be done:

http://www.baldyweb.com/Autofill.htm