Hall of Fame

1. capricorn1520,815
2. DatabaseMX309,174
3. LSMCons...227,148
4. matthews...151,908
5. peter57r113,733
6. GrahamM...110,016
7. JDettman95,759
8. GRayL83,700
9. puppydog...74,770
10. Helen_Fe...69,064
11. cactus_d...56,052
12. thenelson54,468
13. JezWalters47,416
14. SimonAdept46,307
15. fyed45,584
16. Torrwin44,370
17. hnasr37,910
18. kelvinsparks37,252
19. HainKurt35,786
20. Bitsqueezer32,537
21. OxonDev30,775
22. harfang26,090
23. ErezMor24,650
24. Tramtrak23,890
25. tbsgadi23,021

1. capricorn113,726,808
2. DatabaseMX6,601,285
3. rockiroads6,053,947
4. nico50385,705,281
5. LSMCons...5,653,029
6. peter57r5,260,340
7. LPurvis3,656,859
8. GRayL3,394,562
9. harfang3,386,745
10. shanesue...3,288,317
11. stevbe2,861,511
12. boag20002,812,505
13. jimhorn2,808,217
14. matthews...2,703,182
15. mbizup2,388,890
16. thenelson2,344,970
17. flavo2,117,383
18. jadedata1,968,277
19. puppydog...1,962,886
20. jefftwilley1,898,620
21. cactus_d...1,758,344
22. JDettman1,601,851
23. eghtebas1,548,179
24. jjafferr1,344,995
25. dannywar...1,330,887

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

Question

	[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!

7.8

Synchronize two forms

Asked by darkmagneto in Microsoft Access Database

Tags: forms, synchronize, two

OK....I have a pop-up form that has a drop-down with a division in it. That is working fine.

Now, on the OnClick of form 1 I have this:
Private Sub btnViewStatusRpt_Click()
On Error GoTo Err_btnViewStatusRpt_Click

If IsNull(cboDivision) Then
MsgBox "Either select a Division or Cancel.", vbOKOnly
Else
Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmSponsor"
DoCmd.OpenForm stDocName, , , stLinkCriteria
End If

Exit_btnViewStatusRpt_Click:
Exit Sub

Err_btnViewStatusRpt_Click:
MsgBox err.Description
Resume Exit_btnViewStatusRpt_Click

End Sub

That is working fine. It goes to me frmSponsor just fine.

Now, on my frmSponsor I have the record source of the combobox as:

SELECT dbo_IMO_SPONSORS.sponsor_id, dbo_IMO_SPONSORS.sponsor_description FROM dbo_IMO_SPONSORS WHERE dbo_IMO_SPONSORS.application_area_id =" & frmSponsorReportByDivision.cboDivision.Column(0) &" ORDER BY dbo_IMO_SPONSORS.sponsor_description

It keeps giving me a datatype mismatch error.

Please help!

Thanks!
Dark

View the Solution FREE for 30 Days

20100308-EE-VQP-140

Your technology problems solved.

Close See Plans and Pricing. Try it FREE for 30 days.

Synchronize two forms

Asked by darkmagneto in Microsoft Access Database

Tags: forms, synchronize, two

About this solution