frmfind has a list box which is based on a query and an unbound
textbox (txtproduct)

The user enters part of a product code into txtproduct and presses
enter, this fires the afterupdate event which requeries the list box.
Record source for the listbox is a query which is based on
tblproducts with criteria on the field productcode as follows - Like
[Forms]![frmfind]![txtproduct] & "*"

This produces a list of each product where the product code starts
with whatever the user has typed in the textbox. All very simple and
works perfectly...........................

Oddly, if the user only types 1 or 2 characters (which wouldn't
usually be the case!) the listbox returns no records. If I try to
run a copy of the query at the same time I get an error "typed
incorrectly or too complex"

Anyone experienced this?

On 29 July, 16:11, BobbyDazzler <david.a.mitch... (AT) inbox (DOT) com> wrote:
Sorry!!! Found the problem, a null value was the cause, fixed the null
and taken steps to prevent null being accepted. )