Refresh Recordset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Thanks for taking the time to read my question.

My DB is used for billing. Each billable entity has several free-bees. I
use the recordset to see who has used up their free-bees and if they have, I
bill them

I have code that opens a record set. The recordset is based on an NON
updateable query. As I move through the code, I look to see if the entity
has used a free-bee, and if so, I update the table that holds free-bees used.

The problem I am having is this:

I update the table but my record set does not get updated, so if an entity
gets 2 free visits and they have 3 records (and not used any free-bees), the
first 2 will be free-bees but the third should get billed. Since my
recordset does not get updated when I make a change to the table that holds
the number of free-bees, the thrid one doesn't get flagged to be billed.

How can I update my recordset, and still maintain my position in the
recordset? If I close and open the recordset, I'll lose my position in the
recordset and have to start all over, and then I'll over count on free-bees.

Write if this is too confusing, and I'll try to explain more.

Thanks again, I really apreciate the help.

Brad
 
What I did to solve this was I created 2 functions outside of the code I had.
These functions opened the same recordset, but after I have done the update.
That way the recordset contains the changes. I run my tests, and then
return the result to the main code and continue.

Brad
 
Back
Top