Help With A-Level ICT Coursework

[Rgaming]

I am making a database for ICT however, I have a problem which is highlighted in the video below:


The teacher doesn't know therefore I am hoping you experts can help me out.
Please note all the data in the database is made up and not real.


https://www.youtube.com/watch?v=_W1R53moZzk



Any help will be much appreciated.

[ranman256]

There's no need to manually create IDs. Access does this using AUTONUM field. Users/programmer need do nothing.

If you want to make your company internal ID, then you can do what the video asked, just by assigning the text box...
txtID ="C" & txtBox323

this would happen in the btnADD_CLICK() event

sub btnADD_CLICK() 
 DoCmd.GoToRecord , , acNewRec
 txtID ="C" &  txtBox323
end sub

[Rgaming]

Thank you very much