G
Guest
I have a main form that i want to show all records of tblItem in Datasheet
View and when a row is selected populates fields to be edited in Form View on
the same form. I have created two subForms (frmItemInventorySummary &
frmItemInventoryDetails). frmItemInventorySummary is a datasheet view of the
tblItems table, frmItemInventoryDetails is a form view of the tblItems table.
I added both the forms as subforms on a new form frmMain. I have the
following questions:
How do i only allow a user to select the entire row (i.e. if a cell is
clicked the entire row is selected)?
How do i get the value of the [ID] field of the selected record in a subform
in datasheet view?
When a user changes records in frmItemInventoryDetails how do i select the
corresponding row in frmItemInventorySummary?
Thank you for your help and any suggestions to better handle this issue.
Thanks.
View and when a row is selected populates fields to be edited in Form View on
the same form. I have created two subForms (frmItemInventorySummary &
frmItemInventoryDetails). frmItemInventorySummary is a datasheet view of the
tblItems table, frmItemInventoryDetails is a form view of the tblItems table.
I added both the forms as subforms on a new form frmMain. I have the
following questions:
How do i only allow a user to select the entire row (i.e. if a cell is
clicked the entire row is selected)?
How do i get the value of the [ID] field of the selected record in a subform
in datasheet view?
When a user changes records in frmItemInventoryDetails how do i select the
corresponding row in frmItemInventorySummary?
Thank you for your help and any suggestions to better handle this issue.
Thanks.