Full Version: keeping one particular field value in the form when creatind new
UtterAccess Forums > Microsoft® Access > Access Forms
I've got one more question regarding forms.
Omade one form to show the existing records and want to make it to create new records.
So I put one button to create new record.
But what I want to do is when I click the 'create new record' button, the form will show all fields blank and one particular field is autofilled the value that is the previous value of that form.
I can't use default value property for that field because that value will be different depending on the selection of user from the previous forms.
I use the statements like ' DoCmd.GoToRecord , , acNewRec' for creating new record.
Can anyone help me with my problems.
thanks a lot in advance to all of you.
See Microsoft Knowledge Base article 210236
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.