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

Knowing the value of active record

P: 20
Thank you guys for answering my last questions.

Here is again a simple question with a simple answer I suppose...

I need to know how to set in a Variable, the value of an especific column of the active record, so lets be more explicit; in column number 5 that is called "POLICY" of the active record, there is a value I neeed to know, in excel VBA i would do this:

myvar = activecell.offset(0,5).value

What would be the code for an access table?
Feb 11 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
You can't do this in an Access table, and shouldn't! Data entry in Access should always be done thru a form based on the table, and the VBA code would be

MyVar = Me.Policy.Value

Since Value is the Default Property for a textbox, you can actually omit it and simply use

MyVar = Me.Policy

Welcome to Bytes!

Linq ;0)>
Feb 12 '10 #2

P: 20
Thank you so much Moderator, I really appreciate it, I will use it and reply again to let you know what happened, thanks again see ya
Feb 12 '10 #3

Post your reply

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