• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 635
  • Last Modified:

How do I "Refresh" a query?

I have a form that uses two combo boxes to seelct criteria for a query.  Then in a subform I use the query in a combo box to make a third selection.  However, whenever I make my first two selections and then move to the subform, nothing is displayed.  If I then switch to design mode, and then back to view mode, the valid selections are available.  How do I "Force" the query to run the first time I enter the subform?
0
StuBabyAight
Asked:
StuBabyAight
1 Solution
 
Emil_GrayCommented:
In the On Enter event for the subform use:

Me.Requery
0
 
StuBabyAightAuthor Commented:
Cheers
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now