Populate a Combobox from another forms Textbox (1 Viewer)

[Malcolm17]

Hello,

I'm trying to populate the first\default value of a Combo Box when I make a form visible with the value of a Textbox on another form. The Textbox value will be same as one of the 6 in the Combo Box. The Combo Box is just to allow the user to change the department and will be picked from a table.

Is this possible - I can't seem to make it happen.

The code I am using to copy to value from textbox to combobox is: (it works for textbox to textbox)

Forms!frmBackground!subfrmUserEmployee!cboDepartment = Forms!frmBackground!subfrmUsers!txtDepartment

Thank you,

Malcolm

 

[pbaldy]

The syntax might be off:

Forms: Refer to Form and Subform properties and controls

Also make sure you're copying the expected value. For example, if the textbox contains a department name but the bound column of the combo is an ID field.

 

[Malcolm17]

Fabulous, I have been looking at it for hours - turned out to be an issue with the bound column.

Thank you, Malcolm

 

[pbaldy]

Happy to help!

 

[Pat Hartman]

The code will dirty the form and that is a problem. I would put it in the subform's BeforeInsert event. That way, it will only happen if the user starts to enter data.