List Box

B

baconroll

I have a list box which I use to choose a client from then print a report.
The problem I have is that when I close the report and go back to the reports
form, even though I can disable the list box, the next report still prints
out with the filter chosen from the previous report. Is there anyone to
refresh that list box to make it default to blank?
 
B

baconroll

thank you Henro, works great

Henro said:
me.[listboxname].value = null in the after_update event?

baconroll schreef:
I have a list box which I use to choose a client from then print a report.
The problem I have is that when I close the report and go back to the reports
form, even though I can disable the list box, the next report still prints
out with the filter chosen from the previous report. Is there anyone to
refresh that list box to make it default to blank?
Click to expand...
Click to expand...
 
H

Henro

I am no access wizard like so much of the folk here but I am happy I
could put in my two pence :p

baconroll schreef:
thank you Henro, works great

:

me.[listboxname].value = null in the after_update event?

baconroll schreef:
I have a list box which I use to choose a client from then print a report.
The problem I have is that when I close the report and go back to the reports
form, even though I can disable the list box, the next report still prints
out with the filter chosen from the previous report. Is there anyone to
refresh that list box to make it default to blank?
Click to expand...
Click to expand...
Click to expand...
 
Top