Problem with List Box in ACCESS'97

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

Guest

I am trying to change the rows displayed from a listbox on a form. I have tried using a parameter query bu
I get a prompt when the form opens and I want the listbox to appear empty on open. I then want a comman
button to run the query which will prompt for a parameter which will then filter the listbox results. But I can'
get it to work, including how to have it NOT prompt when the form first opens. Perhaps there's a better wa
to do this?

HEL
 
Mike,

This page shows how to change what's shown in a combo box, but the process
is the same for a list box.
http://www.pacificdb.com.au/MVP/Code/ComboRS.htm

As for killing the prompt, just remove the RowSource from the listbox when
in design view.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

MikeSS said:
I am trying to change the rows displayed from a listbox on a form. I have
Click to expand...
tried using a parameter query but
I get a prompt when the form opens and I want the listbox to appear empty
Click to expand...
on open. I then want a command
button to run the query which will prompt for a parameter which will then
Click to expand...
filter the listbox results. But I can't
get it to work, including how to have it NOT prompt when the form first
Click to expand...
opens. Perhaps there's a better way
 
Back
Top