A
Arnie
I have a series of command buttons number 1 to 12 that open a new form where
I can select different attributes which then updates information on the
original form (reason for this is the editing is password protected) one of
them is a combo box which has a list from a table called “Cables†the list is
1 – 12 which when selected passes data back into the cables text box on the
original form. if I select number 2 I want it to disappear from the list for
that record ie 1, 3, 4, 5 etc so that I don’t have users select cable 2 more
than once for that record. When I go to the next record I want to be able to
have all 12 available to select again and so on
Do I use a query on the combo box or vba code someone suggested using a
query and in criteria using “is not nullâ€.
Hope this makes sense
I can select different attributes which then updates information on the
original form (reason for this is the editing is password protected) one of
them is a combo box which has a list from a table called “Cables†the list is
1 – 12 which when selected passes data back into the cables text box on the
original form. if I select number 2 I want it to disappear from the list for
that record ie 1, 3, 4, 5 etc so that I don’t have users select cable 2 more
than once for that record. When I go to the next record I want to be able to
have all 12 available to select again and so on
Do I use a query on the combo box or vba code someone suggested using a
query and in criteria using “is not nullâ€.
Hope this makes sense