Ive got a bound form which displays the last record that has been entered in the database.
this shows the details: ProductID, Desc, quantity, size, price etc..
i done it using:
Forms!frmProduct.Recordset.FindFirst "ProductID = " & DMax("ProductID", "tblProduct")
Now on another form what i want to do is show the next Number in the ProductID that a product will be entered on.
So an example could be that the last ID in my form is 82 which has a spanner.
So when a user goes to add another product,
Ive got a bound ProductID box which i want to display 83 because thats were the next item will be added.
How could i do this?
Thanks..
this shows the details: ProductID, Desc, quantity, size, price etc..
i done it using:
Forms!frmProduct.Recordset.FindFirst "ProductID = " & DMax("ProductID", "tblProduct")
Now on another form what i want to do is show the next Number in the ProductID that a product will be entered on.
So an example could be that the last ID in my form is 82 which has a spanner.
So when a user goes to add another product,
Ive got a bound ProductID box which i want to display 83 because thats were the next item will be added.
How could i do this?
Thanks..