Subform Cursor Gone Wild

[mmckinnon]

Hi All,

I have a mainform that hold a template for house remodeling. Then I have a subform that holds the tasks needed to accomplish the house remodel. The subfrom is a list of continuous records. On particular fields in the subform, I use an append query to add records as needed. The problem is that once the append takes place the cursor goes back to the first record. How do I get the cursor to stay on the new appended record.

Similar to the above problem, there are certain fields in the subform that are updated. When a value is changed, a macro runs that includes an update query to update the cost totals on the subform and on the mainform. When finished, the cursor jumps to the mainform and has the first record selected in the subform. I just want it to go to the next field in the subform as if I had no macro at all.

The macro looks like this:

Save Record
Open Query (update query)
refresh
removefiltersor t

Any ideas on how I can tame the wild cursor?

Thanks!

[ADezii]

Hi All,

I have a mainform that hold a template for house remodeling. Then I have a subform that holds the tasks needed to accomplish the house remodel. The subfrom is a list of continuous records. On particular fields in the subform, I use an append query to add records as needed. The problem is that once the append takes place the cursor goes back to the first record. How do I get the cursor to stay on the new appended record.

Similar to the above problem, there are certain fields in the subform that are updated. When a value is changed, a macro runs that includes an update query to update the cost totals on the subform and on the mainform. When finished, the cursor jumps to the mainform and has the first record selected in the subform. I just want it to go to the next field in the subform as if I had no macro at all.

The macro looks like this:

Save Record
Open Query (update query)
refresh
removefiltersor t

Any ideas on how I can tame the wild cursor?

Thanks!

Try this Link first, if it doesn't help then respond to the question.
http://www.thescripts.com/forum/thre...-bookmark.html
Where is the Update Query being run from?

[mmckinnon]

Thanks much for the answer. I will try it out now. The query is being run from a macro, After reading some of the the posting here I'm beginning to realize that running anything from a macro may not be the best idea. Thanks and I will let you know if this works.

[missinglinq]

That's right! Macros are rigid and very limited in the abilities, and more importantly, have no provision for error handling!

Welcome to TheScripts!

Linq ;0)>

[mmckinnon]

Thanks. The code works and brings me back to the record which is great(!) but it doesn't bring me back to the correct fieild--so I'm almost there. Is there a way to bookmark the exact field?

[ADezii]

Thanks. The code works and brings me back to the record which is great(!) but it doesn't bring me back to the correct fieild--so I'm almost there. Is there a way to bookmark the exact field?

You can experiment with code similar to that which is listed below:

Static ctl As Control
 
'Set the Absolute Path to your Control
Set ctl = Forms!frmEmployees!subfChild.Form![FirstName]
 
DoCmd.OpenQuery "<Action Query here>"
 
'Return Focus to the Original Control
ctl.SetFocus

[mmckinnon]

Works Perfect. Thanks for all of your help!

[ADezii]

Works Perfect. Thanks for all of your help!

Glad it worked out for you.