List Box

[BT24]

Hello there

well i have a list box and when you Pick one of the entrys whats supposed to happen is that the other list box is supposed to be updated. But when i click on the entry nothing happens. it works in the query. so i dont know what the problem is. the code that i have is this:
Private Sub AreaList_AfterUpdate()
[DescriptionCombo].Visible = False
End Sub

Private Sub AreaList_Click()
[DescriptionCombo].Requery
[DescriptionCombo].Visible = True
End Sub

Private Sub Form_Open(Cancel As Integer)
[DescriptionCombo].Visible = False
End Sub

i think that it is not requerying.

thanks for whatever help you can give

BT24

 

[GKProgrammer]

Hi BT24,

What are you trying to update DescriptionCombo to? I notice in the AreaList_Click event that you requery and make visible the DescriptionCombo control but you don't seem to be changing the rowsource for the control at all. So there is nothing for the control to requery too.

Regards,
gkprogrammer

 

[BT24]

Hello there
what the DescriptionCombo is updated from which of the Areas are chosen. there are about 40 descriptions for each area. so instead of having 120 entrys if the user clicks on an area it will sort only the 40 from that area

Thanks for the help, i hope that answers the question

BT24

 

[BT24]

Hello,
I got it to work because i didnt have the criteria right in the query, it was looking up a field that didnt exist. But now i would like to know is is there away so that i could link two different tables? There are 3 areas and in each area there are employees so when i click on the area it will open the Description List box but it will also open the employees list box for the employees in that area. thanks for the help

BT24