can anybody hear me...
hey my previous thread not replied even after 16 views..if you are not clear about my problem let me know but do reply...pleasssssssssssssse.....

the problem is.....

i have two combobox dcbequipment and dcbarea....

the code is...


Private Sub dcbequipment_gotfocus()
Dim intarea As Integer
Select Case dcbarea.BoundText
Case "1"
intarea = 7000
MsgBox "intarea=" & intarea
Case "2"
intarea = 6000
End Select
...
....
' missing code....help me...:-(
...
....


End Sub

I want dcbequipment's rowmember and inturn listfield changed based on intarea..... but the commandtext is not taking the value of intarea...
i am wrong somewhere..where ??

help please...

sandip