How to Link list Box with Form

[ghost]

Greeting,

I have a form for entering and search for info. In this form there are text
box for search and listbox for showing search results. What I want to do is
once search results appear, the user will dbl click on the results he wants
and the form fields show the details of that item. I put the following sql in
the form control source :
SELECT utilizing.* FROM utilizing;

And the following sql for list box
SELECT utilizing.idn, utilizing.founame, utilizing.proname,
utilizing.utilizdate, utilizing.lumpvalue, utilizing.notes FROM utilizing
WHERE (((utilizing.founame) Like "*" & forms!utilizing!serutill & "*"));

And on the event dbl click of the list box :
Me.RecordSource = "SELECT utilizing.idn, utilizing.founame,
utilizing.proname, utilizing.utilizdate, utilizing.lumpvalue, utilizing.notes
FROM utilizing WHERE (((utilizing.founame) Like " * " &
forms!utilizing!serutill & " * ")); "
Once I dbl click on the list box item that I want , a message appears and
tells" type mismatch error 13"
Any help please?

 

[Wayne-I-M]

Hi

Douglas Steel gave a very clear answer to this error here

http://groups.google.com/group/micr...roup:microsoft.public.access#b628d609243e26d0

You need to check the formats of the fields you are looking for and
filtering on.