
Signature
Wayne
Manchester, England.
On Apr 30, 8:40 am, Wayne-I-M <Wayn...@discussions.microsoft.com>
wrote:
> Hi
>
[quoted text clipped - 25 lines]
>
> - Show quoted text -
Hi Wayne,
I tried this however the code stops at:
rs.FindFirst "[Category] = " & Str(Me![Combo24])
I'm wondering is this because the category column is itself a lookup
field in a table, therefore instead of showing say, "Credit" it is
reflecting it;s numerical position on the list say "1"?
Wayne-I-M - 30 Apr 2007 20:54 GMT
Hi
I wouldn't use a lookup field in a table (have a look around this forum as
there are zillions of referecne to the problems this may cause). You may be
better using a combo (instead of the lookup field) linked/sourced from the
table (the one you are referencing in your lookup at the moment).
AfterUpdate on this new combo you could set focus to the next combo and run
the GoTo.
Ensure that you set the bound column (of the 1st comb) to the something that
means something - like the string/text name and not the placeing in a list as
this seems a bit strange to me.
Note that am not refereing to a casscading combo but simply an afer update
setfocus and run code - there is a difference.
Give it a try and let us know what happens. It may be a little extra work
but I think you will find it helpful.
Hope this helps

Signature
Wayne
Manchester, England.
> On Apr 30, 8:40 am, Wayne-I-M <Wayn...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 35 lines]
> field in a table, therefore instead of showing say, "Credit" it is
> reflecting it;s numerical position on the list say "1"?