simulating telesales operation

[prodigy]

I have developed a MS-Access application for a small call-center (20 users).with approx 1500 customer-records to call everyday.
What I have done:
There are 20 front-ends residing at the Telecallers desktop and 1 database@server. Presently I am allocating 1500 records (clients send 1500 data everyday) everyday to 20 telecallers so that they get their respective calling details (75 records/telecaller). The no of cases that they need to call is predetermined.
They see cust-details and call up the customer manually.
What I intend to do:
I don’t want to allocate records to telecallers. Instead, when they open the FE-screen they will get the record that is available. (Of course keeping in mind that no particular record is opened by more than 1 telecaller).
Any help in this regard is highly appreciated. Any idea will encourage me to make the application more pro.

 

[prodigy]

Thanking Pat

Hi Pat Hartman,
I have gone through ur reply. The idea/concept that you have helped me with is wonderful. I appreciate that you have taken up time replying the issue in such an easy manner. I will try as you have advised. Thanks.

 

[Rich1968]

Operators tools

I finally figured this out.

Using Pats suggestions. I could not get this to work with requery. So I set up the following.

Create a Macro. Call it Next Record

1. Set warning to "NO"
2. Close form
3. Run query
4. Open form
5. Close query

Create a button. Set to "Next Record"

It Works!

Now if anyone can help me with code to do the same, I would be grateful!

Pat, Sincere thanks for your being the super moderator!

Rich1968