Default values in a form

[Aleem]

Hi,



I have converted access DB to MS SQL database, while the code is still in Access.

There are several form, when invoked have default values (kind of template) these work fine in Access but not in converted application these default values show up after the record is saved.

Any ideas

Thanks

Aleem

[June7]

Check the DefaultValue property the form controls. If nothing there, then there is code that is populating the fields.

Can MSSQL fields have a DefaultValue setting, like in Access tables?

[lfpm062010]

There are 3 places could have deafult value assigned.

1) Access Table can have default value defined.
2) Like June mentioned, the form "DefaultValue" property can defined default value.
3) SQL Server Table can also have default value defined.

[Aleem]

Thank you for your replies. Sorry that I wasn't very clear.

Access table has default values, that are transferred to SQL server. When run against access database the forms display default values when form is invoked.

The issue is when the application is run against SQL Server, the default values do not get populated till the record is saved. So basically the user has to Save the form first to get the template. And if he/she wants to cancel it, that is not possible.

Thanks

Aleem

[June7]

Are you saying the form does not show the default values when bound to linked SQL table? Sorry, I don't know SQL database, maybe that is proper behavior.

[Aleem]

Yes, That's right.

To me it seems that when record is created, Access populates the fields with default values. While SQL Server populates the null fields with default values upon saving.