How to Run Oracle Sequence to MS Access

[niko66623]

i have a MS Access form the one with VB Code
Now i have a big problem about how to run a sequence created from oralce to increment my Cust_No in table Cust_Service

actually i did not develope this appz im just enhancing it this all that i need
Cust_No is on a textbox and i wish it would go autonumber everytime i create a new data

this very hard for me cuz i did not create the system and i jump from graphics to programming

any help is most appreciated
thank you

[debasisdas]

In your case it is not atall necessary to take value from sequence in Oracle.

if u want cust_no to increase automatically then find out the max value on the field and increase the value by 1

use MAX() function for this purpose.

I think u can do that much in VB

it is so simple..