Combo Box field selection help needed

[techexpressinc]

I have a couple comboxes on the form.
I cannot get the highlight value to add to the table. It is always the 1st one, even thou I have highlighted a different client.



My value for & Me!ClientID & is the 1st one not the highlighted one.
My value for & Me!FSWID & is the right one.

I need the ClientID to be the highlight value any suggestions on how.
I included some pictures to help show the problem.

Thx Russ

"
If rs!Inactive = False Then
sql = ("insert into TicklerData(TicklerID,ClientID,FSWID,Item,Due,Sort Order) values (" & maxid & "," & Me!ClientID & "," & Me!FSWID & ",'" & rs![Item] & "','" & DateDue & "'," & rs![SortOrder] & ");")
DoCmd.RunSQL (sql)
End If

[pbaldy]

Me!ClientID is pulling data from the form, not the combo. Try using

Me.ClientSelectBox

[techexpressinc]

How would you write that like:

Me.ClientSelectBox.ClientID
or
Me!ClientSelectBox!ClientID
or
??


Last try that failed - Me!ClientSelectBox.ClientID
see below

If rs!Inactive = False Then
sql = ("insert into TicklerData(TicklerID,ClientID,FSWID,Item,Due,Sort Order) values (" & maxid & "," & Me!ClientSelectBox.ClientID & "," & Me!FSWID & ",'" & rs![Item] & "','" & DateDue & "'," & rs![SortOrder] & ");")
DoCmd.RunSQL (sql)
End If

I think you are on the right track.

Thx
Russ

[pbaldy]

I'd write it exactly as I suggested:

Me.ClientSelectBox

Presuming the bound column of the combo is the client ID, that should work.

[techexpressinc]

Method or Data member not found message with this

If rs!Inactive = False Then
sql = ("insert into TicklerData(TicklerID,ClientID,FSWID,Item,Due,Sort Order) values (" & maxid & "," & Me.ClientSelectBox & "," & Me!FSWID & ",'" & rs![Item] & "','" & DateDue & "'," & rs![SortOrder] & ");")
DoCmd.RunSQL (sql)
End If

[pbaldy]

Based on the picture of the property sheet you posted above, that's the name of the combo. Has it changed? That should be whatever the name of the combo is.

[techexpressinc]

The property sheet has not changed.

I do not understand the field name you describe to use, is this:
" Me.ClientSelectBox "

That is the name of the whole Combo Box, not a particular field within it. I need the query to point the field Clientid within the combo box. So, shouldn't the field name be more like:
"Me.ClientSelectBox.Clientid " ?

Thx for the help.
Russ - Rneuman @ Scaninc.org

[techexpressinc]

You are correct! No wonder you have the famous MVP by your id.

All I needed was the: " & Me.ClientSelectBox & "
I must be a sequence thing. That it was updating the table field Clientid and then some since the field name in the table was Clientid and there was a Clientid in the ClientSelectBox there was a match and that field from the ClientSelectBox was picked.

Thanks for the help.

Russ

[pbaldy]

No problem Russ; glad you got it sorted out. FYI, to reference a particular field within the combo, you do it by column:

Me.ComboName.Column(x)

where x is the desired column (it is zero based). But as you've found, you don't need to do that to get the bound column.