Refresh All goes back to First Record

[diane802]

Hi - In the form I have created, which is recordset type - dynaset (inconsistent updates) - since I have linked in Queries that are based on indeterminate relationships...

I need to click "Refresh All" - since its linked to Queries... When I click "Refresh All" above, it automatically reverts back to the First Record.



How can I keep it on the record in view?

Also - is it possible to have the Form, refresh all on its own, without having to click?

[RuralGuy]

Explain again why you need to click "Refresh All", please.

[diane802]

I realized its because I changed the Recordtype Set to Dynaset (Inconsistent Updates)

When you do that - I think it makes you hit refresh all.

[diane802]

if I can recreate my other fields, so that there aren't many to one/many relationships... then maybe I won't need it to be set to this specific recordtype?

[RuralGuy]

It did not mention that little "benefit" in the help file I was reading. Maybe this is all you need.