When I use this code from the website the second combo box selects the id of the record I am calling from table Well Counts by Lease SEPT 2008 instead of the actual field attribute. For example, I am selecting a field unit (CC_NAME) as the attribute for the first combo box (combo85), I want a billing code number (CCNO) populated in the second combo box (combo 91). But instead of it selecting the field name it is selecting ID 21. SInce I am not using the ID it does not coerelate to a number. Is this correct? Or what am I doing wrong?
On Error Resume Next
Combo91.RowSource = "Select [Well Counts by Lease SEPT 2008].CCNO " & _
"FROM [Well Counts by Lease SEPT 2008] " & _
"WHERE [Well Counts by Lease SEPT 2008].CC_NAME = '" & CC_NAME.Value & "' " & _
"ORDER BY [Well Counts by Lease SEPT 2008].CCNO;"