Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 145
  • Last Modified:

get data from row on a subform in access

I have a subform on a main form and i have used the double click event on the row of the subform, what I want to do is grab the string in that row, how do I do that in vba?
0
PeterBaileyUk
Asked:
PeterBaileyUk
  • 9
  • 4
1 Solution
 
PeterBaileyUkAuthor Commented:
i tried this but this only reveals the record number:
WordArray() = Split(Me.CurrentRecord)
0
 
PeterBaileyUkAuthor Commented:
ok i worked it out

WordArray() = Me.[DecodeResult].Value


so maybe the question can be closed by moderator.
0
 
PeterBaileyUkAuthor Commented:
WordArray() = split(Me.[DecodeResult].Value)
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Gustav BrockCIOCommented:
Yes. Just click Request Attention top-right.

/gustav
0
 
PeterBaileyUkAuthor Commented:
well again short thrift from a moderator this time, I really don't understand why i get the "telling off" if you don't want me on here then make a payment adjustment and close the account. I don't know all the rules.

Certainly a bit of courtesy to the people who pay wouldn't go amiss.

If you all carry on this way you will drive the payers away.
0
 
PeterBaileyUkAuthor Commented:
And I just went to close it myself as "ordered" and it wants me to justify the decision. Now are you getting the conflict here. I dont win.
0
 
Gustav BrockCIOCommented:
Sorry, forgot that.
I don't post that many questions myself, and normally just close them marking as answered.

Peter, don't forget some of us pay with our time.

/gustav
0
 
PeterBaileyUkAuthor Commented:
I never forget the experts generosity of time, that's why I always treat them with courtesy. The mods reply was appalling.
0
 
Gustav BrockCIOCommented:
Then feel lucky this isn't UtterAccess. It's like driven by a sect, and pitty you should you step sideways. The priests will cut your hands or ban you.
At EE a decent staff runs the shop. And they communicate like ordinary people.

/gustav
0
 
PeterBaileyUkAuthor Commented:
Well i've made my feeling clear on this. I couldn't do right for doing wrong. His or her reply comes across as "don't waste my time calling me with this nonsense"

Moderate yes but not like that.
0
 
Gustav BrockCIOCommented:
OK, but forgive. I'm sure it wasn't meant that way.

/gustav
0
 
PeterBaileyUkAuthor Commented:
Absolutely nothing wrong with forgiveness but what bugs me more is the air of arrogance of the moderator. They dont apologise or anything but I guess if they think they are god.
0
 
PeterBaileyUkAuthor Commented:
i worked it out
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 9
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now