Query running automatically

[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

 

[Allen Browne]

To can force the form to query again, use Requery.

 

[Guest]

can you exlain how i would do this

To can force the form to query again, use Requery.

 

[Allen Browne]

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