We help IT Professionals succeed at work.
Get Started

MS Access continuous form with dropdown that should show for each row different data depending on value of another field in same row

Last Modified: 2019-12-06
This is an Access 2013 VBA question.

I have a subform of type continuous form that shows selected rows of data from a table. in the first field I have a kind of record type, say A or B. In the third field, which is shown as a a combobox, I have a value that has to come from two different data sets depending on the record type. I.e.
- if record type is A, then the dropdown in the third field should show a set of values (selected from a separate table, in a column that holds the possible values of the 3rd field  for record type A)
- if record type is B,  then the dropdown in the third field should show a different set of values (selected from the same separate table, in a column that holds the values of the 3rd field  for record type B)

I am really stuck with that user requirement, and don't know if I should have
 - 1 or  2 comboboxes for the 2 record types and ony show one or the other
- 2 separate select statements depending on the type
- and even how to find out, when the row is displayed, if record type is or B.

There doesn't seem to be an event that I can catch when each row is being displayed, so that I could populate the values for the combobox(es) properly depending on the record type

Any idea how I can do what the users want ?

Thanks for help.
Watch Question
IT Supervisor
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE