Problem with List Box DblClick Event: Please Help!

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.
 
J

J. Goddard

It is confusing -

but it sounds as if there is a query somewhere that is referring to a
fieldthat it does not recognize.

When you populate the list box from frmusersearch, what does the query
look like, how do you populate the list box?

John
 

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

Similar Threads


Top