Runtime Error on assigning a ComboBox value to a control on a Form

[hlogoma]

Hi,



I have this control, ctljoinEmployeeId, on my form and it is empty at the time that I want to assign a value to it.

In the add a record mode, I fill-in a combo box, cboEmployee, by choosing an employee name. In the After Update event for this combo box I assign the EmployeeName to a control, ctlEmployeeName, and all is well. Also at this point I want to assign the EmployeeId to a control, ctljoinEmployeeID. In the AfterUpdate for the for the Employee combo box the code to assign the EmployeeID is: Me.ctljoinEmployeeID = Me.cboEmployee.column(0). Both of the data types are text and the ctljoinEmployeeId is bound to a table field whilst the cboEmployee is bound to yet another table field, more correctly two fields, the name and id.

Any idea why I am getting a runtime error on this assignment or any suggestions as to how I can assign the cboEmployee.column(0) attribute to ctljoinEmployee control?

Thanks,

Tom.

[boblarson]

Why are you storing the name and the ID in the table? You should ONLY be storing the ID in the table. The Employees table already has the name so you would be violating the rules of normalization to store it. You can DISPLAY it simply by using

=[ComboNameHere].[Column](1)

provided that the combo's row source has the name and that the combo's column count property is set to the number of columns in the rowsource.

[hlogoma]

Why are you storing the name and the ID in the table? You should ONLY be storing the ID in the table. The Employees table already has the name so you would be violating the rules of normalization to store it. You can DISPLAY it simply by using

=[ComboNameHere].[Column](1)

provided that the combo's row source has the name and that the combo's column count property is set to the number of columns in the rowsource.

Hi Bob,

Thanks for your reply .... I will look into this to see if it is giving me the runtime error.

Tom.

[khalid]

....
the number of columns in the rowsource.

Hi Bob, welcome Sir, is this your first post to the forum? my title has been changed in the Access World Forum to Newly Registered user

[boblarson]

Hi Bob, welcome Sir, is this your first post to the forum? my title has been changed in the Access World Forum to Newly Registered user

Yes, this was my first post here. And as far as the title goes, you should still be able to go into your CP and set the custom user title. Just don't use the last one you used

[khalid]

Hahaha bob, I know I will be kicked off this time if I use it again , and I have heard that you are giving AWF VIP title to some beloved hmmm