I'm new to this forum and i've been working with acces for about 2 days now. I have a form in which I have two combo boxes and depending on what is selected on the first dropdown the second one gets populated accordingly, which is great! There are two problems;
First the when I select the value from the second drop down the value in the first and second combo box go away!!
Second when I remove the filter the values for all the other text fields show up and I can scroll through each record. So it appears that my filter is not working in the way I want it to which is when the Second value is picked from the combo box all subsequent text fields will be popluated. A little back ground: there is only one table, I have include the following in the first combo box event procedure:
Expand|Select|Wrap|Line Numbers
- Private Sub Combo81_AfterUpdate()
- If IsNull(Me.Combo81) Then
- Me.FilterOn = False
- Else
- Me.Filter = "Company= """ & Me.Combo81 & """"
- Me.FilterOn = True
- End If
- End Sub
Expand|Select|Wrap|Line Numbers
- SELECT DISTINCT [Sales Funnel1].Company
- FROM [Sales Funnel1]
- WHERE ((([Sales Funnel1].[ASC Rep Reporting])=Forms!Opportunity!Combo83))
- ORDER BY [Sales Funnel1].Company;
-Dev1