J
Jacine
I designed a form using a parts table and a subform based on a query from two
other tables.
The subform based on the query are bin location fields (text) and a units
field (numeric) for each bin location for table 1 and an actual physical
count field (numeric) for table 2.
I am trying to run an update query using a command button to update the
numeric field from the actual physical count field but I only want it to
update the current record and not sure how to do this.
Thank you.
other tables.
The subform based on the query are bin location fields (text) and a units
field (numeric) for each bin location for table 1 and an actual physical
count field (numeric) for table 2.
I am trying to run an update query using a command button to update the
numeric field from the actual physical count field but I only want it to
update the current record and not sure how to do this.
Thank you.