View Full Version : default value problem


Emmanuelle
05-03-2001, 06:13 AM
Hi everyone

I don't have a clue what's going on with my form and subform.
In my form "Dataset Update" there is a subform "SirDatabase subform" which show all the manipulations done to one dataset. For each manipulation the dataset has a new update level. My field update level in my subform has a default value which is the maximum value found+1. As I update records from the subform, the update level is increasing not by one all the time but by 1 then 0 then 1 then 0.......

my default value is as below:
=DMax("[updatelevel]","sirdatabases","[DatabaseName]=" & "'" & [Forms]![SirDataUpdate].[cboSirDatabasesNames].[Value] & " '")+1

what have I done?? help me please
emmanuelle