combo box filtering

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a record where i select which pair of fibres have been used. which is
held in a table Pairs and passed to another table once selected. if pair 1 is
selected for record1 in record 2 i only want to be able to select pairs 2-12
etc can anyone tell me should i use code in the combo box or create some kind
of filter

ta in advance
 
Ofer not quite what i was looking for maybe i didn't explain myself i have a
form representing 12 slots in a piece of equipment each slot is represented
by a command button click on the command butoon ie slot 1 it opens a form
that displays information about that slot if you want to edit it you select
the edit button this displays a similar form which has dropdown boxes and
editable text boxes. one of the dropdown boxes has a list 1 to 12
representing pairs of a fibre if in this form i select 1 representing pair 1
then close the form the un-editable form appears with 1 in the pairs text
box. if i use pair 1 when i select the second command box slot and go through
to the edit stage i only want to see pairs 2 to 12 available and so on
 
Back
Top