QUOTE (AC2Designs @ Apr 9 2010, 01:52 PM)
Can you give a little more info on what you are trying to do?
Maybe some example data...
My form is called Main IP, I have a combo box that I would like to include any related projects, for instance record number 1 may also be linked to records number 20 and 50. I would like the combo box to be able to record these numbers which is nice and straight forward. I then want to be able to access the linked record by clicking on the combo box so if you are looking at record 1 and see that record 20 is linked you can click on that and it will take you to record 20. I have this part working ok, however the problem occurs when you look at another record, say record no 2, this might be linked to some other projects on the database but different projects, 99 and 120. So for record number 2 I would like to change the values of the combo box from 20 and 50 to 99 & 120 but still keep the functionality of navigating to the selected record.
Is a combo box the best thing to be using here?
I hope this has made things clearer.