Prev: Tester Position (QA),Halifax
Next: Update a treeview node?
From: BobbyDazzler on 29 Jul 2010 11:11
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?
From: BobbyDazzler on 29 Jul 2010 11:40
On 29 July, 16:11, BobbyDazzler <david.a.mitch...(a)inbox.com> wrote:
> 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?

Sorry!!! Found the problem, a null value was the cause, fixed the null
and taken steps to prevent null being accepted. :o)
 | 
Pages: 1
Prev: Tester Position (QA),Halifax
Next: Update a treeview node?