Requery without losing position

[Jay Cook]

Hi, I have a form with a subform on it, when i click in the first field (on
Enter on the contiunous subform) I need a field on the main page to requery.
the problem that i am having is whe I requery i lose the position my cursor
is in.

Is there and way to just requery the field or am I going about this wrong

Thanks in advanced

Jay

 

[Roger Carlson]

You are requerying the entire form. You want to just requery the control on
the form. Something like:

Forms!MyForm!MyControl.Requery
or
Me!MyControl.Requery

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Jay Cook]

Hi Roger

that does requery the control perfectly, but it still make my cursor go to
the top record in the subform

thanks

Jay

 

[Chris Reveille]

Try

Me.refresh

Chris

-----Original Message-----
Hi Roger

that does requery the control perfectly, but it still make my cursor go to
the top record in the subform

thanks

Jay


.

 

[Jay Cook]

Thanks for the help, it refreshes the sub form but I need the textbox on the
main form to refesh

thanks again

Jay

 

[Jay Cook]

I think I almost got it but the go to record doesn't work, any suggestions?

Thanks


Dim crId As Integer
crId = Me.CurrentRecord
Forms!editTripFile!List35.Requery
Forms![editTripFile]!TripLegs.Form!TripLeg.SetFocus
DoCmd.GoToRecord , , acGoTo, crId