I'm about to pull my hair out, over this one.
For my database, I have a table with a list of state names and abbreviations to be used in comboboxes, and also region numbers (1-13) associated with the states. The setup behind my problem goes like this:
Table with state abbreviations in first column, state names in second, and region numbers for each in third.
I have a form where users will enter data on new Clients. The address and contact info is entered in a subform, in which the combobox for choosing the state has bound column set to 0 (because it needs to store the state with the address in the table), column count 3, and the other two columns' widths set to 0. I'm trying to get the region number from the third column of the selected state to populate a region field in the main form.
The region field is also a combobox, but getting its value from a list of just region numbers (1-13) instead of from the table (to avoid repeats and include 13 for "national", which wouldn't be in the state table).
I can't get it to do anything. I've tried several different methods, but most the things I've read seem to indicate that I need to use .column(#), so that's what I've got right now. Can anyone see what I'm doing wrong?
Code:
Dim insdRgn As String
insdRgn = Me.ctlCtcSt.Column(2)
Forms!frmClientAdd.Controls!ctlCltPrimRgn.Value = insdRgn