Combobox on main form does not requery combo box on sub form

[jermaine123]

Hello Guys,

I am a newbie to Ms access. I am having a problem with a modified Order Details form from Northwind 2007.

This form has a main form (Order Details) that has a Beneficiary ID combobox. It also has a subform with the fields ITEM, QUANTITY, PRICE, DISCOUNT SUBTOTAL AND BENEFIT ID (Combobox)
Each Beneficiary has one or more benefits that they have selected beforehand and all transaction items will be assigned to one of the selected benefits.

When I first open the Order Details form and choose a beneficiary from the CUSTOMER ID Combobox on the main form, the correct benefits that were selected for that person are shown in the subform in the BENEFIT ID Combobox.
If I should choose another beneficiary the correct information is also displayed. IF I SHOULD CLICK IN THE DATASHEET ON THE SUB FORM AND THEN CLICK BACK ON THE CUSTOMER ID FIELD ON THE MAIN FORM AND CHANGE THE BENEFICIARY,
then the benefits selected in the Benefit ID combobox of the subform do not change.

The benefits displayed in the combobox of the subform should be requeried each time a different beneficiary is chosen of the main form. I have tried the following code and various other things but with no success. I suspect that I may not be using the correct form events.

I have attached a TEST DB.
Username: Test Employee
Password: Test
VBA Password: rocky123

Just log in and choose the New Transactions button on the home page. Please let me know what I am doing wrong.




MAIN FORM - Customer ID afterupdate event

Private Sub Customer_ID_AfterUpdate()

Forms![Order Details]![sbfOrderDetails].Form![BENEFIT ID]= NULL
Forms![Order Details]![sbfOrderDetails].Form![BENEFIT ID].Requery
Forms![Order Details]![sbfOrderDetails].Form![BENEFIT ID]= Forms![Order Details]![sbfOrderDetails].Form![BENEFIT ID].ItemData(0)

End Sub


MAIN FORM - Form Current Event

Private Sub Form_Current()

Forms![Order Details]![sbfOrderDetails].Form![BENEFIT ID].Requery

End Sub

[RuralGuy]

Why do you use a WhereCondition of "1=0"?

[jermaine123]

Which control/macro are you refering to? I am sure that was a part of the original Northwind DB form

[jermaine123]

I found the solution in another forum. All I had to do was put ....

sbfOrderDetails.Form!Benefit_ID.Requery in the On Enter event of the Sub form control

Thanks for your help

[RuralGuy]

Glad to hear you got it sorted. I guess you are ready to follow the link in my sig and mark this thread as Solved then, right?

[jermaine123]

I marked the thread as solved. thanks man

[RuralGuy]

You are more than welcome. Just glad you came up with the solution.