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
ZKMPk Reports are NOT used to input data. Reports ONLY display data.
You must manage your data through forms. Forms ARE used to input data.
George Hepworth I know this brother. but i want make a checkbox on report which i check or uncheck and the data update from form is it possible?
Sorry George but you can use buttons on reports. They will be visible and usable on reportmode. You are right when you mean that you can not use them on printpreview.
They come in handy when you want to show a preview with options for different kind of versions.
Greetings,
Marcel