Query running automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a drop down menu of names, which feeds into a query to show ID's for
that name, on the same report form, as you change the name drop down to
select a name (john smith) the query runs and returns all ID's for Jon Smith
and shows these in another drop down, hwoever, if you then change the drop
down name field the query doesn't run again and instead show only John
Smith's ID's not the new persons, if I close down the form and select a
different name it works once then again it sticks, what am I doing wrong
Matt
 
Presumably you want to force the requery when an unbound text box is
updated?

If so, set the AfterUpdate property of the text box to:
[Event Procedure]

Click the Build button (...) beside the property.
Access opens the code window.

Between the "Private Sub..." and "End Sub" lines, enter:
Me.Requery
 
Back
Top