How to reset recordset of a form?

[101287]

I have a form that I use to update records. I use this form to add records. The problem that I'm having is that I when I add a record I need to "refresh" the form control. Or refresh the recordset set for the specific record that I added. Any suggestions regarding how to reset the record set of a form after adding a record.

Thank you again for all the help and guidance.

Luis

 

[TheAceMan1]

How are ya 101287 . . .

Have a look at the [blue]Requery[/blue] method:

[blue]   Me.Requery[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[101287]

Tested Requery but did not reset the record set in the updatable table. Thank you for suggestion.

Luis

 

[MajP]

I think you need to be a little clearer in what you are trying to accomplish. AceMan's solution will refresh the form with the changes in the underlying table, but it sounds like you want something more or different. Please explain this:
but did not reset the record set in the updatable table

I do not understand what that means. I do not think your terminology is correct or at least it is confusing.

 

[TheAceMan1]

101287 . . .

[ol][li]What are you expecting to happen when you [blue]Refresh[/blue]?[/li]
[li]Is the form [blue]unbound[/blue]?[/li]
[li]How are you saving?[/li][/ol]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]