Combo box value needs to change with record...

[dragginthru]

There are two main methods of navigating around the top-level form on the database I am currently working on.

One is by a drop down menu listing GP practice names - so you can scroll down to "Dr Watson" for example and then all the subforms display the correct info.

The second way is by clicking on "Previous Surgery" or "Next Surgery". This is obviously a lot easier for data entry than having to use the drop down menu each and every time!

However there is a problem, in that when one uses the second method - the highlighted value in the combo box does not change! You can literally navigate through hundreds of surgeries, and though the address changes in the subforms etc "Dr Watson" is still proudly displayed in the combo box.

So we have a situation where it would be pretty easy for someone entering data to think they were on the correct record when in fact they were not, leading to errors in input.

Is there a way to force the combo box to "refresh" to the same value as the current record, effectively displaying the title?

Thanks
Gazz

 

[dragginthru]

sorry to repost - anyone got any ideas on this?

 

[Bat17]

I cant test it at the moment but you may be able to do it by setting the default value of the combo from the oncurrent event of the form

Peter