J
Jdougal
I have a form that has several inputs. One of the inputs is the number of
employees working during a shift. This is a drop down box and the options you
have are predetermined. I need to change the available inputs on another
record in the form. This change needs to be done according to the input on
the first record.
If 3 people are working I only want people to be able to select group 1,2,3
If 2 people " " select group 1, 4
I believe I need to use queries but am unsure of this, and if so, how to go
about doing it. Please advise.
employees working during a shift. This is a drop down box and the options you
have are predetermined. I need to change the available inputs on another
record in the form. This change needs to be done according to the input on
the first record.
If 3 people are working I only want people to be able to select group 1,2,3
If 2 people " " select group 1, 4
I believe I need to use queries but am unsure of this, and if so, how to go
about doing it. Please advise.