var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I need to know how to requery a record. I currently have the form set to Requery.Me but everytime I do that it jumps me to the first record and but I need it to requery the current record and not drop me back to the first one.
Nevermind figured it out:
FYI the answer is below...
Dim k as integer
k = Me.CurrentRecord
'(your stuff happens here)
DoCmd.GoToRecord , , acGoTo, k
'To get back to the control (textbox bound to a field) that the user was on previous to the requery you add:
Dim strControl As String
run other code
me![strVariable].SetFocus 'or Docmd.GoToControl strControl
strControl = Me.ActiveControl.Name
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors