Subform won't update

[Scrofani]

Again, I am REALLY new at this.

I have a form "holdings" with a subform "results" list box that points to a query. Above the subform I created a combo box with a drop down choosing from a list of ticker symbols. When I change the ticker, I would like the subform to update automatically. To try to get around this, I added a button/macro that updates the query and closes it. But the subform does not update unless I close and reopen the "holdings" form.

I search through this forum and saw many of these types of questions and many responses have been docmd.requery but I am unfamiliar with coding. I figured there had to be an option in Properties of the subform (i.e. OnCurrent) that would solve this.

Thanks for the help.

 

[zemp]

What tools are you using, MS Access? Search for a form, at the top of this page, specific to your database and tools.

BTW, welcome to Tek-Tips. When you have time take a look at faq222-2244 on how to get the most from the forums.

zemp

 

[willir]

Let the Access wizard do the coding for you. Make sure the wizards are enabled (toggle button, bottom left corner, second button from the left -- magic want icon). Add a command button, and then choose "Form operations" as the category and "Refresh from data" as the action.