Hey I am REALLY new at VB and teaching myself as I go. I have run into an issue and not been able to find a solution so far. What I want to do is when I open my new work order form the form generates the next WO number. I have already setup my SQL column as Identity and Set the increment to 1 and Identity seed to 1000. I linked the text box to the WO column but I don't know what code to write so that when it opens it pulls the next WO number.

Thanks for your help
Ray