Forum Discussion
default field
I'm creating a table in access and want the NickName field's default value to equal FirstName. How do I do this?
You can do this in the form where you enter your data.
In the text box control for NickName, put this in the DefaultValue property:
=[FirstName]
This will ONLY work, of course, if you have previously put some value in the FirstName field.