Requery Issues

[Purpleswanage]

This probably should be really easy but I can't get it to work.

My main form has a number of fields which are Combo boxes drawing their values from tables. In event that the required value is not available I need to be able to DblClick on the field to open the source table to add the new value (that bit I have sussed). What I can't make happen is that value appearing immediately in the Combo Box on the main data entry form. The code I am using is as follows:

Private Sub Program_DblClick(Cancel As Integer)
DoCmd.OpenTable "Program"
Me![Program].Requery

End Sub

As I said, it's probably something really simple. All help gratefully received.

Helen

 

[KenHigg]

I would suggest having form that opens to add the item to the list table. Then in this forms close event requery the combo box.

 

[Purpleswanage]

Thanks i'll give it a go!

Helen

 

[Purpleswanage]

Thanks. Have used a form to add values and the performed a requery on the 'Got Focus' to update the main data entry form.

Thank you for your help.

Helen

 

[KenHigg]

Cool - Glad yougot it to work