Showing Active record in continuous forms

[Monica Lemaire]

I have a CONTINUOUS form that shows all record in a table. I would like it to be very obvious to a user which record they are sitting on so they can press a button and open a different form to edit that record. Any help would be greatly appreciated.

 

[wiltshire]

What I've done on my databases is to use a list box which shows the user which record they are sitting on (it highlights the line in black). Then on the properties of the list box, on the 'on click' setting, update a sub-form on the form which shows the data you want to show for the active record on the list box.
Hope this makes sense - I've found it a really neat way of displaying data in my own databases.

 

[trucktime]

Active record

You can use Conditional Formatting, when the record has focus it changes the background and/or foreground color.
Do a search on this subject in this forum, there are many posts regarding this.