info generated on a form then being sent to a table

[Lindopski]

Hi I have a field on my form called cost of order
I also have a field called deposit on the form that is generated by dividing the cost by 2.
is there a simple way (most probably) to the send this data to my payment table, I already have a deposit filed set up in the payment table I just want to post the data in from the form?

 

[Lindopski]

well what happens at the mo is.
I input a total cost in one form field and the deposit field below in the form has a little forumla in the Control Source =[Cost of Order]/2
the deposit will always be 50% no changes there but once this data has been inputted the table updates the total cost field but leaves the deposit amount at nothing.
its as though the data isnt going from form to table as I am not manually inputting a deposit required the form generates it.

 

[Lindopski]

right thanks for that Pat ill take all this on board and change things accordingly.
I am an absolute starter when it comes to access and evrything is new to me I do understand some basics however and what you say makes sense. I didnt know for example that I could calculate the deposit on a report which is mainly what it will be seen on. Ill get back on it and see how it turns out , thanks again

 

[Lindopski]

Perfect , works a treat and does all I need thanks for the tips , its the easier stuff like this I dont know , and not knowing Access very well I get a bit lost.
a very handy tip and info thanks