We have some MS Access programs that have links to SQL Server tables as the back end. When a new record is created, the users would like certain date fields etc to have default values. I have gone into SQL Server and given the fields these default values, but when they create a record in access, it seems to ignore them. How do I get the default values to show up?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Default values on SQL Server not showing in Access Form
- Thread starter -cush-
- Start date
Did you refresh the link to the SQL Server table(s)? Also, the defaults don't always display as early as they do with Access. If users don't see the defaults after refreshing the links, you can set the defaults in the form controls.
Duane
Hook'D on Access
MS Access MVP
Duane
Hook'D on Access
MS Access MVP
- Status
Similar threads
- Locked
- Question
- Locked
- Question