Emmanuelle
Registered User.
- Local time
- Today, 14:56
- Joined
- Mar 8, 2001
- Messages
- 11
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
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
