Report is not showing correct information

[mrdod]

I have a form that asks the user if he/she would like to view a report, delete the entry, or assign as task. If he/she selects View Report then I have a bunch of small text boxes that get populated using Dlookup. Then I have a the form popping up and getting the information from the form. My problem is sometimes the form displays old information. It acts like it isn't refreshing itself.


Here is the code for opening the report
Case Is = "View Report"
DoCmd.OpenReport "rptaudit", acViewPreview
Form_frmoptions.Visible = False

Any help would be great.

Thank you.

 

[mrdod]

OK, I did some thinking which is always scary and got it to work by deleting the form right before it's opened (in case it's still open). Not sure it makes sense but it works. Originally there is a list box with all the history, the user double-clicks the entry and the frmoptions appears prompting the user what to do next (View Report, Delete the entry, Assign the entry, etc...). So after double-clicking I made sure that frmoptions was deleted. Make sense???? Maybe I'm doing this the hard way.

Thank you.