S
shn
I built a macro for my dbl click event on a form. The macro works on
the list box correctly when the frmresults form is opened independantly
but not when the list box on the coursesearch form is opened and
populated from another form.
Maybe I should give a little background on the set up. I have a form
named frmusersearch that contains a group of combo boxes and a search
button. When the search button is clicked a qry is started, opens the
frmresults form and populates the list box with the results of the
query.
The results form was created with a generic query so that if the form
is opened independantly the list box is populated with course
information. When the form is opened independantly using the database
window you can dbl click on the record and it pulls up the detailed
record using another form. The problem is that when the frmresults is
opened and the list box is populated from the frmusersearch I get a
message box that states:
Enter Parameter for Forms!frmresults!lstbx_results.Value
I do not understand why the dbl click event works when the form is
opened independantly but not when it is opened using the variable qry
from the other form.
I hope I explained this good enough, it is a litte confusing. Thank you
in advance for any help.
the list box correctly when the frmresults form is opened independantly
but not when the list box on the coursesearch form is opened and
populated from another form.
Maybe I should give a little background on the set up. I have a form
named frmusersearch that contains a group of combo boxes and a search
button. When the search button is clicked a qry is started, opens the
frmresults form and populates the list box with the results of the
query.
The results form was created with a generic query so that if the form
is opened independantly the list box is populated with course
information. When the form is opened independantly using the database
window you can dbl click on the record and it pulls up the detailed
record using another form. The problem is that when the frmresults is
opened and the list box is populated from the frmusersearch I get a
message box that states:
Enter Parameter for Forms!frmresults!lstbx_results.Value
I do not understand why the dbl click event works when the form is
opened independantly but not when it is opened using the variable qry
from the other form.
I hope I explained this good enough, it is a litte confusing. Thank you
in advance for any help.