How do I create an autonumber field (1 Viewer)

[Jamang]

I created a database of "My Cars", "Television", and "Wines" and a Trouble Reports(TR) for each. I have a field TR on each and for now a user can fill it up with number i.e first TR is 1, second Tr is 2 etc etc. I want it automatically filled automatically not manually. However, I want it to do the same for "Television" and "Wines" when I write Trs on them. I am a rookie and I dont know how to do it I attached a copy of the db I created. Olease help.
:banghead::banghead::banghead:

 

[gbil]

i think u can find this useful:

http://www.access-programmers.co.uk/forums/showthread.php?t=252887

 

[Jamang]

Thanks I tried the code to generate new number and I have some problems that I need help. I am so noob when it comes to VB and this will be my first VBA macro I will write. hopefully i can get some advice..