Help with simple VBA code

[lovett10]

First of all i dont know hardly anything about access VBA so thanks in advanced for the help.

What i want is for when i press the button called "Generate Visit Number" in my form, i want it to create the next visit number in the table and place it in the text box "Text4" that is in the form thanks for the help in advanced.

 

[vbaInet]

Do you know about the AutoNumber data type of a field?

 

[lovett10]

Do you know about the AutoNumber data type of a field?

No sorry please enlighten me ... thanks in advance

 

[vbaInet]

Perhaps the following link should give you some pointers:

http://www.ehow.com/how_12383_create-microsoft-access.html

 

[lovett10]

I dont see how that is going to hell me im afraid ... I want a button in the Form to create the next number in the sequence (starting at 15000) and place that number in a text box in the userform. Also place it in a table so that when i save the information on the form it creates a table with the visit number as the key.

Aorry if im being unclear and thanks in advance

 

[vbaInet]

Why do you think the AutoNumber field doesn't meet your needs?

 

[lovett10]

Why do you think the AutoNumber field doesn't meet your needs?

Because it doesnt explain anything like that, i only think VBA can be used for this. Can u please help?

 

[vbaInet]

The AutoNumber field automatically increments and you can start it off from a certain number if you wish. Are you beginning to see how this will work for you?

 

[lovett10]

The AutoNumber field automatically increments and you can start it off from a certain number if you wish. Are you beginning to see how this will work for you?

no not at all im afraid

 

[jdraw]

Watch this free video as a start
http://www.youtube.com/watch?v=1aRv48-3s9w&feature=mfu_in_order&list=UL

then tell us which part you're having difficulty understanding.