Requery form?

[cranebill]

I have a form set up that pulls records that need to be followed up on. When I click a command button it shoots out an email and updates a followup date in the table.

Now what I want to do is have the fields in the form that are bound update and stay on the same record...

For instance if I am on record 4 of 8, I hit the command button and it does what it is supposed to do then requeryies to populate updated fields and stays on record 4.

Hopefully this made sense.

 

[lameid]

For instance if I am on record 4 of 8, I hit the command button and it does what it is supposed to do then requeryies to populate updated fields and stays on record 4.

Is that what it is doing or what you want it to do?

I am guessing that it requeries the form when you do the update in code which may be causing it to disappear form the recordset the form is bound to.

If so, you would have to kill the requery.

 

[PHV]

Did you try the Refresh method instead of Requery ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[missinglinq]

I don't think Refresh will work here. Maybe assign the PK to a global variable, send the email and so on, the use the global variable with FindFirst.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!