I have a field called AcceptReject that is a drop down menu with the choices A or R. When A is chosen I would like the comments form to open and todays date and the A to automatically fill into the comments field. If it is R I want the date and R to fill in. The first problem I have is that I put the code:
If AccpetReject = A Then
open the form and fill in
This is not working, it opens the form and fills it in no matter if A or R is picked.
Secondly, when it puts the date and the A in the field it is wiping out what is already in the comments field, I just want it to add the date and A to the beginning of the field, in front of what is already in there, I don't want it to be erased. I hope this makes sense, if there are any questions please let me know. Thanks.
If AccpetReject = A Then
open the form and fill in
This is not working, it opens the form and fills it in no matter if A or R is picked.
Secondly, when it puts the date and the A in the field it is wiping out what is already in the comments field, I just want it to add the date and A to the beginning of the field, in front of what is already in there, I don't want it to be erased. I hope this makes sense, if there are any questions please let me know. Thanks.