Access 2K - Want a form that displays multiple records for scrolling and editing certain fields.
The Table has many code fields so i use a query to display descriptors of these code fields. But the query is uneditable Attempted solutions and problems:
I tried a single mainform (unbound) containing two subforms side-by-side. Both are continuous subforms.
SubFrom1 is for editing records - bound to a table (on Left side of mainform)
SubForm2 is to display field descriptions about the records in SubForm1 - Subform2 is bound to an uneditable query. SubForm2 has a vertical scrollbar and to the right of subForm1.
Fields common in both subForm Data sources are SSN and Name, both are text fields.
Looking for a way to syncronize the records in the two subforms so they are in sync when they scroll using the scroll bar in subForm2.
OR -my other attempt was placing a listbox (next to the editable fields) on a continuous mainform bound to a table. The listbox displays fields from the uneditable query - but can't figure out how to get rid of the record selectors(up-down buttons) so that listbox displays the data for that specific row.