Auto-refresh bound list box

  • Thread starter Thread starter Pat Randall
  • Start date Start date
P

Pat Randall

I have an Access 2K database (on file server) used to check in students
to our tutoring facility. As students are checked ‘in’, data is
collected and their name is added to a list box with the other students
who are currently checked in. The list box is bound to a transaction
table. When the student is ready to check ‘out’, double-clicking their
name in the listbox retrieves their record and they are checked out.
Their name is automatically removed from the listbox when their record
is saved.
Now, because of high demand, they plan to use two PCs for the student
check-in process. I need a way of refreshing these list boxes so they
are in sync with each other so that when a student is checked in using
the first PC, their name shows up in the listbox on the first PC as well
as the second PC.
(PC 1 and PC 2 would both be logging into the same database. No
front-end / back-end split yet.)
Any help appreciated!
 
Well, I incorrectly stated that the listbox was bound. It is not. I
resolved this issue by using the form timer event and doing a
listbox.requery every minute. Sorry for any confusion.
 
Back
Top