List Box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
me.[listboxname].value = null in the after_update event?

baconroll schreef:
 
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?
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top