Continuous Forms Setfocus

[samonwalkabout]

I have a Continuous Form with lots of field based on a complex query.

The User can Click on a number field in the form and a pop-up form opens, this form allows them to change the number. When they close the form i run code to requery the main form.

No worries there but.. the focus jumps back to the top left of the form so if the user has scrolled down a few pages, then makes a change the focus jumps.

I have tried refresh, repaint, requery etc etc.

I have the record number on the pop form. Can i requery the form then use the record number to set the focus of the continuous form back to the correct record?

Thanks

 

[Rich]

Yes, just use the Find rs method

 

[samonwalkabout]

Is that DoCmd.FindRecord ?

 

[Rich]

Dim rs As String
Rs = Me.CustomerID

DoCmd.RunCommand acCmdSaveRecord
Forms!Customers.Requery
Forms!Customers!CustomerID.SetFocus
DoCmd.FindRecord rs

 

[samonwalkabout]

Okay i have played with the find rs code but am getting an error message
"a macro Set to one of the feilds current propertys failed because of an error in a findRecord action argument"

I should also mention that the form in question is a sub form.

Im using-

Dim rs As String
rs = Me.RawMaterialID

DoCmd.RunCommand acCmdSaveRecord
[Forms]![mainform]![Customers].Requery
[Forms]![mainform]![Customers]![RawMaterialID].SetFocus
DoCmd.FindRecord rs

Any idea what the error means? Does it refer to a field setting on the me.rawmaterial feild?

 

[Pat Hartman]

Why are you requerying the continuous form? That is what is causing the focus to shift back to the first record in the "new" recordset. Requery reruns the query and creates a NEW recordset. If all you want to do is to save the current record, use:
DoCmd.RunCommand acCmdSaveRecord

 

[samonwalkabout]

The feild that is updated is a figure thats used in the calculation of several other fields on the form. The Requery is needed to re-run the query and update all the effected fields.

Its all Future finantical Calculations that take diffrent prices (averages, Highest, Lowest) etc. And i know you are thinking these should'nt be stored fields as there are calculated and they weren't, but the users want to be able to fudge the figures as they need to keep there books looking balanced so i have had to add extra feilds which can be edited and hence the problems now.

 

[Pat Hartman]

Ken Lay is probably not going to jail but the people who actually cooked the books probably will.

Let your users enter adjustment transactions keyed to their userID. At least there will be an audit trail.

 

[samonwalkabout]

I have that side of things covered, i just need to be able to requery the form and then refocus the view on the correct line of fields in the form. I have the ID number passed to the pop form so there must be some way of doing this?

Ken who? Have i missed some major news event?

 

[samonwalkabout]

arrrrr Enron guy!

is there anything google cant find

 

[Rich]

Where are you running the code from?

 

[samonwalkabout]

Im running it from the pop-up form. Should i be storing the raw ID before requery and then runnin the code using that ID to jump to the correct record?

 

[Rich]

Dim rs As String
Dim Rs1 As String
rs = Forms!Customers!CustomerID
Rs1 = Me.AddressID

DoCmd.RunCommand acCmdSaveRecord
Forms!Customers.Requery
Forms!Customers!CustomerID.SetFocus
DoCmd.FindRecord rs
Forms!Customers![Ordrs].SetFocus
Forms!Customers![Ordrs]![AddressID].SetFocus
DoCmd.FindRecord Rs1
[Number].SetFocus

 

[samonwalkabout]

Sorry Rich you lost me there, im guessing you are calling find on 2 forms or something??
I have

1 Main Form = (mainform)
1 sub form = (subform)
1 Pop-up form (popform)
And a bunch of fields on the SubForm, im guessing we can call RawID and another lets say raw2ID if we need 2.

So from the close event on the POP-Up form i call a requery in the subform of the main form. And then refocus it to the record i was just on before the requery. Then Close the pop-up form.

Or do i need to be closing the pop-up form , requerying the subform and refocusing it?

Sorry to be a pain begining to confuse myself.

 

[samonwalkabout]

No Worries i have got it working

I just created a function to call the Find Record rs from a text box on the subform that stores the rawid when the pop form is open and resets to null after the function runs.

Thanks for your help and comments Rich and Pat.

Just gotta work out how to get the pop up to pop up where i want based on the xy cords of the pointer and im laughing.