I'm stumped. If the answer's here, I missed it. I have a master form for inputting data about collections of photos. I have another master form with a combo box which calls up collection names. There is a subform on this master form for entering data on individual photos, which are associated with the collection selected in the combo box. The related tables are tblCollection and tblImages. I want to have a second combo box (or any other kind of box) which will display the highest image number (this is not the pk) used so far for a selected collection. In other words, I want to select a collection in the first control and have the second control display the last entered image number related to that collection. Any help will be appreciated.

Hi Clark!!!!!

Have a look at this example it has all the bits your are looking for.

Cheers!!!!!!


lou