Need help with two combobox that update with eachother

[mafu]

Hello, so I am making a stock inventory database and I have a form that I enter products entering our store. I have one combobox that is the cathegory and an other combobox that is products. I want to select a cathegory and depending on that I later have a filtered list on my products combobox. I have managed to do this setting an event to requery after an update on the cathegory combobox. The problem I have is this is a Continuous Form and when I go to the next record and select a new cathegory the product from the previous product gets errased because the list for the product combobox has changed. How can I solve this?

Thank you

[MadTom]

 Private Sub Form_BeforeUpdate(Cancel As Integer) 'Provide the user with the option to save/undo
On Error GoTo ErrHandler                       'changes made to the record in the form
        bWasNewRecord = Me.NewRecord
    Call AuditEditBegin("tblParts", "audTmptblParts", "P_ID", Nz(Me.P_ID, 0), bWasNewRecord)
    If MsgBox("Changes may have been made to this form or form maybe blank!." _
        & vbCrLf & vbCrLf & "Do you want to save these changes?" & vbCrLf & "Can't save Blank form!" _
        , vbYesNo, "Changes Made or Blank ...") = vbYes Then
        DoCmd.Save
    Else
        DoCmd.RunCommand acCmdUndo
    End If
Exit_ErrHandler:
    Exit Sub                                                         ' Exit before error handler.
ErrHandler:                                                          'jump to on error.
   Call LogError(Err, Error$, "Form_BeforeUpdate_()", P_ID)      'log errors to tLogError table
Resume Exit_ErrHandler
End Sub

I use this Sub in my form.

[Bob Fitz]

Hello, so I am making a stock inventory database and I have a form that I enter products entering our store. I have one combobox that is the cathegory and an other combobox that is products. I want to select a cathegory and depending on that I later have a filtered list on my products combobox. I have managed to do this setting an event to requery after an update on the cathegory combobox. The problem I have is this is a Continuous Form and when I go to the next record and select a new cathegory the product from the previous product gets errased because the list for the product combobox has changed. How can I solve this?

Thank you

Made sure the query used for you form has the Products table in it so that you can have a textbox on the form bound to the name of the product. Make the textbox a little less wide than the combo box (about 0.450cm). Place the text box on top op the combo box but aligned to the left, so that all that can be seen of the combo box is the ArrowDown bit on the right. In the Got Focus event of the textbox put the following code:

Me.ComboboxName.SetFocus

In the GotFocus event of the combo box put the following code:

Me.ComboboxName.Requery

As best as I can remember, this is what I've used in many databases. If you have any problem, post a copy of your db or let me know and I'll post an example of some sort.

[Bob Fitz]

Mafu

For the sake of completeness I have attached a very basic db to illustrate the method that I suggested in my previous post. I hope it is useful to you. If you need any clarification or have any questions, please post back.

By the way: Welcome to the forum