combo box and form : record navigation

[sha7jpm]

I have a simple form with a combo box.

the user selects the project code from the combo box and the form shows the details one record at a time.

so I have put navigational buttons on the form so the user picks the project code, then navigates through the instruments for that project.

the problem is of course that the user can navigate further than the list of that project.

i.e user picks project OEW, that has 5 entries, the user navigates through the 5 and continues into a nother record for a different project code.

so is there a way of stopping the user navigating further than the project ode they originally selected?

maybe a if project code does not equal combobox then do not allow goto next record? and flash up a msgbox?

any tips???

sorry if that is very confusing!

ta

John

 

[dynamictiger]

Have you considered using a sub form approach. The sub form would be a query based on the value in the combo box. In this way information would be queried to the specific project.