October 11, 2008 05:18am pdt

1. capricorn1 824,887
2. boag2000 593,176
3. LSMCons... 475,624
4. DatabaseMX 397,147
5. peter57r 302,576
6. harfang 193,752
7. jimhorn 166,190
8. wiswalld 148,653
9. hnasr 106,944
10. ldunscombe 92,086
11. koutny 89,650
12. MikeToole 87,278
13. GRayL 84,047
14. eghtebas 83,813
15. frankytee 77,464
16. TextReport 76,173
17. mbizup 67,384
18. omgang 64,850
19. LennyGray 62,632
20. Rick_Ric... 58,765
21. irudyk 57,550
22. jefftwilley 55,470
23. JDettman 54,770
24. matthews... 53,897
25. dqmq 49,181

1. capricorn1 1,313,129
2. DatabaseMX 748,360
3. LSMCons... 652,992
4. boag2000 642,266
5. peter57r 519,545
6. jefftwilley 340,537
7. harfang 336,273
8. mbizup 270,001
9. jimhorn 269,737
10. wiswalld 188,867
11. frankytee 185,705
12. GRayL 162,115
13. MikeToole 152,096
14. stevbe 146,536
15. LPurvis 121,295
16. matthews... 118,247
17. ldunscombe 113,545
18. JDettman 106,970
19. hnasr 106,944
20. eghtebas 106,058
21. dqmq 102,053
22. koutny 100,675
23. omgang 90,185
24. puppydog... 83,314
25. Rick_Ric... 78,310

06.05.2008 at 03:18AM PDT, ID: 23459618

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.5

Get information from Table

Asked by jppinto in Access Forms

Tags: Form

This is the cenario:

I've a form that shows a record. One of the fields is IDCar (text type) and is displayed on txtIDCar textbox. This form is bound to a table tblConcerns.

On another table (tblPoints) I've 6 fields name Car1ID, Car2ID, Car3ID, Car4ID, Car5ID and Car6ID. They are all of text type. The IDCar that is displayed on txtIDCar textbox can be found in ONE of this 6 fields. The link between this two tablesis the Date field.

I want to go to tblCars, check wich CarxID field has the same IDCar that I've on tblConcerns and get Pointsx field value.

Example:

IDCar value is "235423". I check tblCars record that has the same Date and find this IDCar in Car3ID field. I return Points3 value to the txtPoints textbox on my form.

Can annyone give me an idea on how to do this? If you need more details, please feel free to ask.

Thanks

jppintoStart Free Trial

Keywords: Get information from Table

	Title
1	Combobox multiple bound columns
2	Bound Form with listbox pulling from rel…
3	how to detect if bound field is updated …
4	Expert Discussion : Bound or Unbound
5	Formating bound textbox
6	pass values from unbound textbox to …

Loading Advertisement...

20080924-EE-VQP-39 / EE_QW_EXPERT_20070906

Get information from Table

Asked by jppinto in Access Forms

Tags: Form

About this solution