It is correct.
However, IF your PK is Numeric (integer) and its incremental or auto number, there is an easier way (provided no customers are deleted also)

Code:
SELECT MAX(Cust_ID) FROM Customer
or even , without a loop, just use a rsDataCust.MoveLast, and get the CustomerID.

Is your Original Problem solved, Unable to Adding records?