<div>
You need to Requery the underlying table/query you use..
</div>


You need to Requery the underlying table/query you use..

<div>
Ok So would setting the field to refresh on Click be sufficient?
</div>


Ok So would setting the field to refresh on Click be sufficient?

<div>
It depends..you must give some more info on this...
</div>


It depends..you must give some more info on this...

beatified

<div>
<div class="content wysiwyg-content">
I have a Access DB that I working on which has forms and subforms. I have an area where I need to be able to add car makes models and colors. I am able to bring up a dialog to create a new color or Make but Need the Dropdown update with the new set of options after closing the dialog.<br />
<br />
Thanks
</div>
</div>


I have a Access DB that I working on which has forms and subforms. I have an area where I need to be able to add car makes models and colors. I am able to bring up a dialog to create a new color or Make but Need the Dropdown update with the new set of options after closing the dialog.

Thanks

Access update a drop down after creating new dropdown option.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.