:-(

[kotecha]

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

[murtagh]

Is this change on a database ie Access ??? More Info required.

[kotecha]

yes... i have used dataenvironment.... and
several commands...

the first datacombo(dcbarea) record source is from one of this command..
but for dataequipment ( second combo box) i want specific records from the table based on the selection at dcbarea..

I hope you are able to understand my prob..

thanks...

[RIVES]

What you should do is in the dropdown event of the second combo, you should requery or filter your result set based on the criteria of the first combo.

requery:

with dataenvironment.rsseconddropdown
if .state <> 0 then .close

.open "select code, description from seconddropdown table where code = '" & firstdropdown.currenttext & "'"

end with
seconddropdown.refresh


filter:

dataevironment.reseconddropdown.filter (blah blah)
seconddropdown.refresh

Hope you get what I mean.

[kotecha]

Dear Rives...

thanks for the reply..but still....

1. dropdown event is not for datacombo so i tried it on gotfocus event

2. to the height of surprise it is giving error at .open (query).... "Microsoft jet database engine could not find the input table of query.." i.e. second drop down table....

any clue ?

Thanks for your efforts...

Best Wishes....