I run the following to print a report. I can't get the requery to work. After I preview a report I choose a different report number in the lstRef list box but when I stop the code on this second print job the item selected is still the first one not the new selection. After the first preview, every preview regardless of which reference number I choose I only get a preview of the first reference number I chose.
How can I refresh the listbox so the new selection is chosen?
Thanks
strRef = Forms!frmPrint!lstRef.ItemData(itm)
Me!txtRef.Value = strRef
'Run Report
cmdMainMenu.SetFocus
lstRef.Requery
How can I refresh the listbox so the new selection is chosen?
Thanks
strRef = Forms!frmPrint!lstRef.ItemData(itm)
Me!txtRef.Value = strRef
'Run Report
cmdMainMenu.SetFocus
lstRef.Requery