database not resetting

[sunshine076]

I have a db that is not resetting once a selection is selected. It will reset after the db has been shutdown and restarted. What the form is suppose to do is pull from two tables and when selected only give the customer's part information for that particular one. Any suggestions would be greatly appreciated. I have done this before and don't remember how I did this.

 

[boblarson]

What do you mean by RESET?

 

[sunshine076]

What I mean by reset is when you are in the form and select a customer name it does not give you the current customer list. For example you first select GE and in Parts it will give you all parts relate to GE however, when you select Rolls Royce it still will show the Parts for GE. It will not reset itself until after you have closed access and reopen it will it then show you the list for Rolls Royce. However, from there if you select a different customer it will only give you part information on Rolls Royce.

 

[boblarson]

You need to add a requery of the second combo box into the After Update Event of the first:

Private Sub Combo6_AfterUpdate()
    Me.Combo10.Requery
End Sub

And you should rename your combos to something that actually describes them, like renaming combo6 to cboCustomer and combo10 to cboParts.

 

[sunshine076]

Thank you that work