Hi,

I am trying to add a combo box that has different values depending on the record. The combo box is called related projects and I would like to add different numbers to each box depending on the record and then set up so that when you click the number it takes you to the correct record. I have the last functionality working but not sure how to make the values unique to the record.

Any help would be greatly appreciated.

Cheers

Neil

Can you give a little more info on what you are trying to do?
Maybe some example data...

Kevin

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.

Cheers

Neil

What is your forms recordsource?
Is the controling ID a part of this recordsource?
How is your combobox populated? (value list, table/query)

I believe you need to create a query (rowsource for the Combobox) which looks at the REcord ID. As you change the records, you need to requery the combo to show the new
records based on the new ID. You can do this in the Form_CUrrent event.

Kevin