Cascading Combo Box

[freightguy]

Hi everyone

I am working on a shipping program and one of the subforms contains a list of technologies and technology description (similar to Category and Product Name).

On the subform I have two combo boxes. The first provides a distinct list of "Technology" and the second combo box provides a list of "Technology Description". The second combo box is dependent on what the user selects from the first combo box.

The problem I am running into is when I get to the second combo box. The moment I start typing or try to enter a character a "Enter Parameter" pop up message comes up. If I type the technology type then the second combo box list populates as it should. How do we get rid of the POP UP message? See snap shot of message and below is code I am using the "AFTER UPDATE" event of the first combo box.

Private Sub Technology_AfterUpdate()

    ' Update the row source of the Tool combo box
    ' when the user makes a selection in the Technology
    ' combo box.
    Me.Tool.RowSource = "SELECT ToolDesc " & _
                            " FROM tblTechnology " & _
                            " WHERE technology = " & Nz(Me.Technology) & _
                            " ORDER BY ToolDesc"
                             
    Me.Tool = Me.Tool.ItemData(0)

End Sub

I have the second combo box set as follows:
control source: Tool
Row Source: empty - see code
Row Source Type: table / query
Bound Column: 1
Limit to List: no (maybe should be set to yes to control data validity but not worried about that right now)

thank you all

 

[MajP]

Is the technology combo bound to a hidden numeric field? if not and it is really returning AFO need to wrap it 'AFO'
technology = '" & nz(me.technology,"") & "'" &

 

[isladogs]

Cascading combo boxes work well on single forms.
Indeed I use them in several of my apps. For example https://www.access-programmers.co.uk/forums/showthread.php?t=302126

However it is much more unusual to attempt these in continuous forms or datasheets. There is an example in this forum by CJ_London which may be worth looking at https://www.access-programmers.co.uk/forums/showthread.php?t=275155&highlight=Cascading+combo

 

[Minty]

Try using

Nz(Me.Technology,1)

Where 1 is a valid value ?

 

[freightguy]

thank you all - the revisiting the query and including the quotes did the trick.
Great reading material as well on working around combo boxes. Cheers!