HI All,
Please help me with this problem.
I want to retrieve all fields from an existing record using combo box.
So here I have 3 combo boxes....A,B,C.
In A(1,2,3) are drop down names.
In B(2,3,4) are drop down names
And In C(9,7,8) are drop down names.
In my table I ahve record like: A B C
1 3 7
2 4 8
So If I click on 1 in combo box A , I will ahve to see 3 and 7 whcih is a
record set in an existing table or query.
Private Sub A_AfterUpdate()
DoCmd.ShowAllRecords
Me![A].SetFocus
DoCmd.FindRecord Me![A]
Me![A].Value = " "
End Sub
And My Row Source is:
SELECT DISTINCTROW [Employee].[A]
FROM Employee ORDER BY [Employee].[A];
When I click on A field I am getting error........
Please help me with this bug...........
---------------------------------
Do you Yahoo!?
Get on board. You're invited to try the new Yahoo! Mail Beta.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Great things are happening at Yahoo! Groups. See the new email design.
http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/q7folB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ms_access/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
