Solved

Find Value column 2 does not work

Posted on 2014-11-25
1
180 Views
Last Modified: 2014-11-26
I am using the following expression to fill a field from a value in Column 1 but I cannot pick up the value of column 2, can anybody tell me why it will not pick up from Column 2?


Private Sub txtTACycle1_Change()
Me.txtCycle1Points.Value = Me.txtTACycle1.Column(1)
Me.txtCycle1Progress.Value = Me.txtCycle1Points - TxtBaselinePoints
Me.txtCycle1DISScore.Value = Me.txtTACycle1.Column(2)
End Sub
0
Comment
Question by:Jeffsmith2466
1 Comment
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40466242
Probably because you have set property ColumnCount to 2. It must be 3 or more as the first is 0.

/gustav
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now