ms access - Search returning blanks -

ms access - Search returning blanks -

i had set next

private sub fncombobox_afterupdate() dim strwhere string if not isnull(me.fncombobox) strwhere = strwhere & " , id = " & me.fncombobox me.fncombobox = null end if docmd.openform "mailinglist", , , mid(strwhere, 6) end sub

to pull records query populate contact form. stands when i'm on search form drop downwards (or 1 can type in name) works fine see names in database. when record pulls of fields in contact form blank.

recently number of entries database deleted don't see how alter search function.

in property have row source set query 'findfn' , row source type set table/query.

perhaps i'm not giving plenty info here, if sees solution appreciated.

ms-access access-vba ms-access-2010