Full Version: Editing Just The Highlighted Record
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
AfroSheen15
Hello,
I have a continuous form and it displays all the information correctly. It displays in one line. So, other records are also displayed.
One field called Shift is the field I need to edit every so often. It is highlighted through a conditional field which makes the record look like there's a bar as a selecting. Highlighting a row.

When I double click on the field Shift, that field hides and a combo box pops up so I can change information. Then after completed it reverses.

The problem is that I just want that information to be displayed on the current record that I'm working on, not on all the records.

Is there a way of just editing the "highlighted" record and leave the rest alone until I need to edit another record?

Thanks for your help.
missinglinq
In order for the information shown to be Record-specific, on a Continuous View Form, the Combobox has to be Bound to a Field in the underlying Table. In a Continuous View Form, the Value of an Unbound Control on one Record is that Control's Value on all Records.

If the data in the Shift Textbox is what is being changed by using the Combobox, as it sounds from your description, why not simply use the Combobox, Bound to the underlying Field, instead of the Textbox?

Linq ;0)>
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.