asked on
Access 2010 Visual Basic: How to have “upstream” combobox choice restrict/filter “downstream” combobox choice
Background:
• I have two comboboxes that take their data from linked SQL Server tables.
• The first combobox Temporary_Or_Permanent has the user choose either “Temporary” or “Permanent” as a value.![Temporary_Or_Permanent combobox choices]()
• The second combobox DB_Type should show only data that matches data from the choice made in Temporary_Or_Permanent field once the User clicks to activate the dropdown of the DB_Type field.![Db_Type combobox and underlying database table]()
The Problem:
• I’m struggling to find a way in Visual Basic, in the After Update event, to have the choice of Temporary_Or_Permanent field figure in some kind of filter.
• Do I use a WHERE clause query?
• Is there some specialized function?
• How do I populate a Combobox?
• I have two comboboxes that take their data from linked SQL Server tables.
• The first combobox Temporary_Or_Permanent has the user choose either “Temporary” or “Permanent” as a value.
• The second combobox DB_Type should show only data that matches data from the choice made in Temporary_Or_Permanent field once the User clicks to activate the dropdown of the DB_Type field.
The Problem:
• I’m struggling to find a way in Visual Basic, in the After Update event, to have the choice of Temporary_Or_Permanent field figure in some kind of filter.
• Do I use a WHERE clause query?
• Is there some specialized function?
• How do I populate a Combobox?
Microsoft AccessMicrosoft ApplicationsMicrosoft Office
Last Comment
stuckp1
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
This was very helpful and worked with a minor glitch on my part, I had to use the Access link table equivalent of dbo.Db_Type, namely, dbo_Db_Type.
Again, many thanks!
Peter
Again, many thanks!
Peter
I'll try to implement it and will let you know how things turn out.
Regards,
Peter