G
Granted
I have an inventory databse with 3 tables containg floor, room number, serial
number and type for Monitors, PC's, and Printers.
I have a form for each item that shows one record at a time with the data
setup for easy editing, which is great for creating new records. But when I
want to edit existing data ideally there would be a subform that shows the
same table as the forms source which can be sorted/filtered and then when I
select a record in the subform(datasheet view) the form then goes to the
corresponding record for easy editing.
For example: I filter the subform (table or query in datasheet view) to show
all of the monitors in room 525, then i click on a specific record and the
main form shows that record for easy editing.
The main issue is that the main form and the subform show the same data,
however the main form shows one record at a time.
number and type for Monitors, PC's, and Printers.
I have a form for each item that shows one record at a time with the data
setup for easy editing, which is great for creating new records. But when I
want to edit existing data ideally there would be a subform that shows the
same table as the forms source which can be sorted/filtered and then when I
select a record in the subform(datasheet view) the form then goes to the
corresponding record for easy editing.
For example: I filter the subform (table or query in datasheet view) to show
all of the monitors in room 525, then i click on a specific record and the
main form shows that record for easy editing.
The main issue is that the main form and the subform show the same data,
however the main form shows one record at a time.