Help Using a Text Box to update a Combo Box List

[QezB]

Please help!

I have a Text Box called DisposalID on Form A & a Combo Box on a seperate form (Form B) called DisposalID. The combo box is based on a query.

Once I add data to the textbox I click on a command button to bring up Form B with the combobox. This form also has a command button which allows me to go back to Form A.

The problem is when I add data to the textbox it does not appear on the combobox list unless I close and reopen Form B.

These forms are generated from two tables linked by Disposal ID.

Your help would be much appreciated.

 

[Dennisk]

requery the combo box on form b in the after update event (or not in list event) of the combo box on form a.

 

[QezB]

Thank you for your help.

The box on Form A is actually a text box. I am new to access and unsure on how to implement the requery function in the After Update. Please could you tell me how to do this?

 

[rockyjr]

Thank you for your help.

The box on Form A is actually a text box. I am new to access and unsure on how to implement the requery function in the After Update. Please could you tell me how to do this?

2 choices:

A)Macro
1. Goto the properties of your 1st combo box
2. Click Event
3. click the ... on the right of After update
4. Select Macro Builder
5. Action = requery and Arguments = your field name (you will need to enter field name at the bottom where it says Control Name)
that's it for Macro

or

B) Code Builder
1. Goto the properties of your 1st combo box
2. Click Event
3. click the ... on the right of After update
4. Select Code Builder
5. enter DoCmd.Requery ([your field name])

ie:
Private Sub Form_AfterUpdate()
DoCmd.Requery ([your field name])
End Sub

that's it

Lucas