Hello, I'm fairly new to access and have the following situation.
My database is set up where the user enters a record on a form for inventory tracking purposes with the following fields:
Date / Customer / Incoming / Name / Quantity
Incoming is either In or Out always and 9 times out of 10 if we are getting say for example 5 in we are also giving 5 out. So currently to track it we have to create 2 duplicate entries except change the In to an Out on the 2nd which slows data entry time in considerably.
I would like to create a button on my form that simply takes the last entered record from the user, duplicates it and then changes the in to an out.
Thank you for any assistance you can provide.
My database is set up where the user enters a record on a form for inventory tracking purposes with the following fields:
Date / Customer / Incoming / Name / Quantity
Incoming is either In or Out always and 9 times out of 10 if we are getting say for example 5 in we are also giving 5 out. So currently to track it we have to create 2 duplicate entries except change the In to an Out on the 2nd which slows data entry time in considerably.
I would like to create a button on my form that simply takes the last entered record from the user, duplicates it and then changes the in to an out.
Thank you for any assistance you can provide.