requery combo boxes on another form

[david.paton]

I have a combo box for selecting a town in the address and if the town isn't in the list, there is a button that opens a form to add a town. Once I add the town, I have a OK button that I want to requery the original combo box so that the new town appears in the list but I am not sure of the code to do so. I don't know if it should be vba or sql code.

The form that has the town button is called frmCarers and frmTown is the form where you add a new town. The command button that needs the requery code is cmdNewTown, contained within frmTown. The combo box contained in frmCarers that needs to be requeried is called cboTown.

Thanks,
Dave

 

[June7]

Review:

https://blueclawdatabase.com/notinlist-event-code/

http://www.fontstuff.com/access/acctut20.htm