Forum Discussion
Checkbox or button on Report which update the data and refresh through form (MS Access)
The button will only work in reportmode not in printpreview.
When you are putting the button keep in mind that the report has the information from the table's when it was opened. So the button can change the values in the form but you need to reload the report. I am not covering the part that the report needs to be closed and opened again.
call to the textfield would go like this:
if checkbox.value = false then
forms("form456").textbox.Price.text = forms("form456").Paid.text
'not sure if the line below will do the job. Try and let us know here.
docmd.requery
else
forms("form456").textbox.Price.text = 0
End sub
The button will only work in reportmode not in printpreview.
When you are putting the button keep in mind that the report has the information from the table's when it was opened. So the button can change the values in the form but you need to reload the report. I am not covering the part that the report needs to be closed and opened again.
call to the textfield would go like this:
if checkbox.value = false then
forms("form456").textbox.Price.text = forms("form456").Paid.text
'not sure if the line below will do the job. Try and let us know here.
docmd.requery
else
forms("form456").textbox.Price.text = 0
End sub