coding a form with dynamic record counts

  • Thread starter Thread starter David Bretzke
  • Start date Start date
D

David Bretzke

Hello--

I'm not sure if my title is correct, but here's what I'm trying to do:

I have a form that displays the current number of patients and the total
number of tickets for that patient population as a DLookup to a couple of
text boxes. This information stays static. I have a few filters (on both
patients & tickets) available allowing the user to select a date range and
also patient sub-groups. What I would like to do is have a couple of new
text boxes (under the ones indicated above) that reflects the number of
available patients and tickets based on the current status of the filters. I
would like these to respond as changes are made.

How would I go about doing this? I assume you would use an event handler
(OnChange, OnUpdate, etc.) or to you 'refresh' the form by manipulating the
timer?

Thanks!

Dave
 
Back
Top