more than 2 combo boxes

[MdHaziq]

Hello Steve,



I have set the cascading comboboxes as stated above.

I would like to drop down from terminal to item and change the qty in the backside of the database (onhold qty)

I face a problem when I changed the code.Attachment 30532

[ssanfu]

You do know that you CANNOT requery a text box.... right?????

Private Sub cboitem_AfterUpdate()
    Me.txtqty = Null
'    Me.txtqty.Requery   '<<<--- delete all of the lines like this!
    Me.txtqty.SetFocus
End Sub

Private Sub cboequipment_AfterUpdate()
    Me.cboitem = Null
    Me.txtqty = Null

    Me.cboitem.Requery
'    Me.txtqtyRequery   ' <<--- ERROR - no such variable.... delete this line

    Me.cboitem.SetFocus
End Sub

I would like to drop down from terminal to item and change the qty in the backside of the database (onhold qty)

Sorry. I do not understand what you mean...

[MdHaziq]

Hello Steve,

Thanks for clarifying with me.

On what I want to do with my database is actually for the user to select which terminal, dropdown all the way to the item which says how many items the rack has instock (on hand) preferably in the item dropdown.

The user will type or dropdown the amount they need to withdraw of that item from the rack.

Deducting it from the on hand qty.

TIA

Haziq

[ssanfu]

Good luck with your project........

[MdHaziq]

Good luck with your project........

Thanks for helping me

[ssanfu]

Are you ready to mark this problem solved???

[MdHaziq]

Yes. Thanks for all the help