Form update help (1 Viewer)

[munkeyroot]

Hi Everyone
I am having issues with updating a form to use a report for it.

ok, so i have a form, and on the form i have my text boxes etc to fill in details, and i also have a button that generates a report.

so if i update a small portion of the form by filling in some of the txt boxes details.

If i do not exit the form or go to new record, when i go to us the the button to generate the report the updates to the record do not show, I understand that this would do this, as the access has not updated the row in the table yet. however how do i get around this? I though about making an update button or maybe a tag of code on the report button?

any thoughts would be great full.

i just also would like to say a big thank you for every ones help, i would be bald by now if not

thanks again Munk

 

[CJ_London]

you are probably not saving the data before running the report

in the event where you open the report put

if me.dirty then me.dirty=false

before the line that opens the report

 

[munkeyroot]

Hey CJ
Ahhhh thanks pal, i'll give it a go

munk