Access / Windows 7 issue

[Palmyra]

The below code opened a form and displayed the next sequential number on the form. The form is based on a table with an identity seed.

If bolTest Then
DoCmd.OpenForm "frmVoucher", acNormal, , , acFormAdd, acWindowNormal

It worked in Windows XP, but is not displaying the next id in Windows 7.

Any ideas?

 

[genomon]

Look at the table in design view and make sure the table didn't lose some settings, such as autonumber.

Gluais faicilleach le cupan làn

 

[Palmyra]

It's a SQL table and it has it's identity seed, int, length of 4.

 

[Palmyra]

Table is updateable. Thanks.