Urgent!! Saving a textbox to a table

[Juggy]

Howdy guys,

I have a unbound text box called Person code which is in a subform. The Person code is a number that is copied from the main form down to the subform. I am trying to place this Person code in to a field called PERSON_CODE in the table StudentTable but cant seem to find a way around this. (I am a novice programmer in acces and VBA).

Can anyone point me in the right direction ?? and Appologies if this topic has been covered before

Cheers

Juggy

 

[Mile-O]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=41644&highlight=Syntax