If this is the right way to do it, how do I refill the lookupfields with the
right values since they only get filled once by the query when the form is
opened. How can I refill the lookup lists when the user sets focus to the
related field?
john
"john" <john@test.comschreef in bericht
news:OO6dnQm-eIhfXGfZnZ2dnUVZ8qKdnZ2d@casema.nl...
Quote:
>I have a lookup table with 3 fields that reprensents costs categories,
>something like this:
Fld1 Fld2 Fld3
Holiday Malibu 2005 Hotel
Holiday Alps 2006 Hotel
Meeting Montly meeting Conference room
>
I want to use this lookup table in another table that has the same fields.
This table is in a form. For being able to look up the right value, my
plan is to run a query at the arrival at field 1 to filter the unique
possibilities of category 1. For field 2 I'd like to do something similar
but then filter out only the category 2 items that belong to the choice
that was made by the user in field 2. The same accounts for field 3 in
relation to field 1 and 2.
Is this normal practice in Access or is there a better alternative?
Thanks in advance,
john
>
>
