Retrieving last Number in Field

[David Davis]

Hello,

I am somewhat new at access 2003

I want to retrieve last sequential number in Field1 in Table1 to put in Field 3 of Table2. How do I do this? I tried Nz(DMax("[Field1]","Table1") )+1 in the default value of Field 3 in Table2 but it came up with Unknown Function 'NZ' in validation expression. Can someone help....

Thanks

Dave

[Rabbit]

You going to have to populate it through code.

[David Davis]

You going to have to populate it through code.

Rabbit Thanks for responding,

Can you give me an example please.

David

[Rabbit]

Actually, you probably don't need code. Just put it in the default value property of the control that's bound to the field instead of in the table design.