sql db default value in access

[felix]

Hi all,

I recently changed my Access backend to sql Server 2005 Express. So now I
have the same makros, forms and queries as before except that the tables are
not in my .mdb file anymore but are on the server. In the tables section
(where the tables were before) I have odbc connections with the same name to
the corresponding tables on the sql server.
A big problem I have now is that when I create a new line in any Access
Project it doesnt load the default values until I save the line.
Before I switched to sql server the default values were loaded as soon as I
began to work on a new line.
This is very stressful because I use the default values in Forms as well,
and there they appeared as soon as I began to work on a new line.
Do I have to rewrite all of my forms, or is there a way to tell access to
load the default values immediatly??

thanks and greets

felix

 

[S.Clark]

You can't tell Access to apply defaults to something it doesn't own anymore.

You could create a new record in code, then present that record to the user.
If they cancel. you'll have to delete it, but it beats putting all the
defaults into the form controls.