Hai, I am using MS Acess 2010. I have a form using to keep some tool records. All tools are validated and if I enter a tool number in this form which is not validated, through a MsgBox function, another form opens for a validation records. Everything is fine. I want to store the tool number I entered in the first form and copy it to the validation form tool number field without retyping it in the new validation form. I am not familiar with code. I am trying to set the value through macro action window, but I cant find "SetValue" action in the list. But I can see it in the "data macro" action list. Appreciate your help to bring the SetValue in macro action list.
Thanks