By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,398 Members | 1,164 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,398 IT Pros & Developers. It's quick & easy.

Setting CurrentRecord in a datasheet

P: 6
Hi,

Is there a way to programatically set the current row in a datasheet(subform) (without clicking the row)?Pls let me know.By default,the first row in the subform gets set as the current row.What do I need to do if I had to set it programatically to, say 4th row?

Thanks,
Savita
Sep 4 '07 #1
Share this Question
Share on Google+
1 Reply


FishVal
Expert 2.5K+
P: 2,653
Hi,

Is there a way to programatically set the current row in a datasheet(subform) (without clicking the row)?Pls let me know.By default,the first row in the subform gets set as the current row.What do I need to do if I had to set it programatically to, say 4th row?

Thanks,
Savita
Hi, Savita.

Just two code lines
Expand|Select|Wrap|Line Numbers
  1. Me.SubformName.SetFocus
  2. DoCmd.GoToRecord Record:=acGoTo, Offset:=4
  3.  
Regards,

Fish
Sep 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.