Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Subform won't update

Subform won't update

Subform won't update

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.  
Replies continue below

Recommended for you

RE: Subform won't update

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.


RE: Subform won't update

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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close