Repeat last entry but automatically change 1 field.

[Gabbelgak]

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.

 

[welshgasman]

Probably the easiest way as you only have 4 controls would be assign required controls to your own variables

MyDate = Me.Date

Add new record

DoCmd.GoToRecord , , acNewRec

The assign your variables to the controls

Me.Date = MyDate

Add a test for In or Out and swap the value for that control.

This will work on the current record of the user.

HTH

 

[Gabbelgak]

Is it possible to do similar without any code? (When I transfer code between my home and work computer the work computer automatically deletes all code - Macro's are fine)

Thank you for the above though to get me started.

 

[Gabbelgak]

I figured out a way, using similar to what you suggested. I created an invisible text box and just used it as a variable.
Store the value from your control using SetValue then retrieve it after moving to a new record by setting the value of the control to the invisible text box.

 

[welshgasman]

I'd be looking at fixing that, as I do work at home as well when I have to, and that does not happen to me. I'd fully expect you to have to use VBA at some point, so it would be worth fixing.

Is it possible to do similar without any code? (When I transfer code between my home and work computer the work computer automatically deletes all code - Macro's are fine)

Thank you for the above though to get me started.

 

[Gabbelgak]

I'd be looking at fixing that, as I do work at home as well when I have to, and that does not happen to me. I'd fully expect you to have to use VBA at some point, so it would be worth fixing.

I know the cause of it actually, not something I can fix unfortunately, I simply have to work around the limitations put upon the hardware I work with.

 

[welshgasman]

Can you email the code to work and then paste it in there.?

Good luck anyway.

 

[Gabbelgak]

Yes I can, However if I then export my work to home and bring it back in I have to repaste the code. So in using code I would have to keep a running a list of all items that have code to paste in every time I go to / from work.