link fields

[Guest]

I have a table 'vehicle details' consisting of 2 fields
1 Fleet Number
2 Registration Number
In a form I have 2 combo boxes for the above and what I would like to do is
to be able to either select 1 field and the other would automatically be
filled or even better would be to select either field and the other would be
filled.
Thanx in advance
Al

 

[Guest]

Not sure why you need two combo boxes. If both fields are in the same table
you can use one combo box to display both fields, you just need to make sure
that the registration number is included in the row source query for your
first combo box and set the column count and column width properties
accordingly