Certain parts of my forms are not saving input!?

[trizzytt]

When i enter data on my form it calculates everything perfect, i click Save, click close the form, and when i come back, certain data disappears. i am unsure why i have made a new save button and also saved manual way ( rather than use my own made button.)


I've attached images of what exactly goes missing, I'm unsure why these fields disappear after i save.


https://imgur.com/a/hn09B

 

[pbaldy]

Nothing with "Unbound" (empty Control Source) will save, nor will any calculated controls (=something + somthing). To save calculations:

http://allenbrowne.com/casu-14.html

 

[trizzytt]

Nothing with "Unbound" (empty Control Source) will save, nor will any calculated controls (=something + somthing). To save calculations:

http://allenbrowne.com/casu-14.html

EDIT:


Infact these are the boxes that nothing in them, they are just text boxes. how do i make them bound?

 

[pbaldy]

You tell Access which field you want the data saved in with the Control Source property of the textbox. If it's empty, Access doesn't know where to save it, so it can't.

 

[trizzytt]

Nothing with "Unbound" (empty Control Source) will save, nor will any calculated controls (=something + somthing). To save calculations:

http://allenbrowne.com/casu-14.html

I also just noticed they are not saving in my table too :S

 

[pbaldy]

The form is a window to the table. If you want those saved, put the appropriate field name in the Control Source property.

 

[trizzytt]

You tell Access which field you want the data saved in with the Control Source property of the textbox. If it's empty, Access doesn't know where to save it, so it can't.

Ah got them to show now! and save! perfect thank you!


Only one that wont save is my Total profit, for the control source it has =[Text156]-[MOT]-[Total Part Cost]+[Labour]. how can i keep it with the calculations and do what you said?

 

[pbaldy]

Happy to help! Check the link in post 2 regarding calculated values.

 

[trizzytt]

Happy to help! Check the link in post 2 regarding calculated values.

Hello,
Thank you i will give this a go now!


When it tells me to add
Private Sub Quantity_AfterUpdate() Me.Fee = Round(Me.Quantity * Me.UnitPrice * 0.1, 2) End Sub

Do i copy this exact, or will i change some information?

 

[trizzytt]

This is my box

https://imgur.com/a/ypMz0,


when i tried what it said in the link you gave me, i just recieved errors. ive reverted it back now. im unsure what i can do.

 

[pbaldy]

What error(s) did you get exactly? That looks about right for the code. The "Fee" control can't have a formula in it.