<div>
Try: <br />
<br />
Forms!Form1!YourCombobox.R<wbr />equery
</div>


<div>
In the code of your Command Button in form 2 that closes the form, add:<br />

<div class="bullet">
Forms!NameOfForm1!NameOfCo<wbr />mbobox.Req<wbr />uery
</div>
<br />
<i>Edit... same as Jeff posted above.</i>
</div>


In the code of your Command Button in form 2 that closes the form, add:

Forms!NameOfForm1!NameOfCombobox.Requery

Edit... same as Jeff posted above.

<div>
I am so sorry... I forgot one thing. &nbsp; There will be times when form 1 isn't open. &nbsp;So the code has to check for that first. &nbsp;<br />
<br />
??
</div>


I am so sorry... I forgot one thing.   There will be times when form 1 isn't open.  So the code has to check for that first.  

??

<div>
Here you go:<br />
If CurrentProject.AllForms(&quot;N<wbr />ameOfForm1<wbr />&quot;).IsLoade<wbr />d = True Then<br />
&nbsp; &nbsp; Forms!NameOfForm1!NameOfCo<wbr />mbobox.Req<wbr />uery<br />
End If
</div>


Here you go:
If CurrentProject.AllForms("NameOfForm1").IsLoaded = True Then
    Forms!NameOfForm1!NameOfCombobox.Requery
End If

<div>
Hmmm, that didn't work. &nbsp;When I got back to form 1 the records in the combobox were not requeried.
</div>


Hmmm, that didn't work.  When I got back to form 1 the records in the combobox were not requeried.

<div>
Steve,<br />
<br />
1. Ron's coding looks solid...<br />
(silly question, did you substitute your actual object names in his code...?)<br />
;-)<br />
<br />
2. Make sure you code is actually &quot;adding&quot; this value to the underlying table...<br />
For example, if you run Ron's code, ...immediately open the *Table* that stores this value, ...is the value added?<br />
<br />
JeffCoachman
</div>


Steve,

1. Ron's coding looks solid...
(silly question, did you substitute your actual object names in his code...?)
;-)

2. Make sure you code is actually "adding" this value to the underlying table...
For example, if you run Ron's code, ...immediately open the *Table* that stores this value, ...is the value added?

JeffCoachman

<div>
<div class="content wysiwyg-content">
I have a combobox on form 1 which the user uses to select a record to open form 2. &nbsp;When form 2 closes via a command button I want the records in the combobox on form 1 to be requeried.<br />
<br />
How can I do this?<br />
<br />
--Steve
</div>
</div>


I have a combobox on form 1 which the user uses to select a record to open form 2.  When form 2 closes via a command button I want the records in the combobox on form 1 to be requeried.

How can I do this?

--Steve

How refresh/requery combobox on 1st form when 2nd form closes

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.