Dennis-
Yes, you could certainly do that in the After Update event of the first combo
using VBA. Would need more details before I can give you sample code.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Dennis Davidsson
Sent: Sunday, August 26, 2012 3:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How to let contents of one combo box affect contents of
another combo box
Hello,
I have a form containing a combo box A and another combo box B. Depending on
what the user selects from the available alternatives in combo box A, I want the
code to force a certain choice among the alternatives in combo box B without the
user having to select the combo box B at all.
Could I achieve this by adding some smart VBA code e.g. on the 'After Update'
event of the combo box A?
Or is there some other better way?
Regards
Dennis Davidsson
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Tidak ada komentar:
Posting Komentar