Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

parameter query

Status
Not open for further replies.

priapus

Technical User
May 17, 2001
26
US
I'm kindof a newbee to access, so if this is trivial sorry. In a form, I have an unbound list based on a query, one of whose fields has a parameter value. On the same form, I have a text box (a date defaulted to the current date that can also be changed manually). That date is the object of the paramaterized field in the query that the list is based on. when the date's changed, the list isn't refreshed dynamically. what do i do? thanks in advance.
 
On the after update event of the date field you will need to do a Requery on the form.

Me.Requery. This should update the form and all the related fields as you need them to.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top