M
Mike71
Hi all
This is most assuredly a novice question, as I'm sure I found a solution to
this before and can't remember it now!
I have two fields, Category and Type, taken from a single table. Each
category has a number of types associated. On the entry form, I've set the
Category field to a SELECT DISTINCT query. What I want to do is get the Type
field to restrict available entries to the relevant Category.
I've got the following query set up:
SELECT Categories.Type
FROM Categories
WHERE (((Categories.Category)=[Forms]![Call Detail Entry Form]![Category]));
This works fine for the first record. However, when a user moves to a new
record, the Types from the first record show up regardless of the Category
selected. The only way to reset it is to close the form completely.
I'm sure this is easy, but as a complete novice to Access VBA I'm at a loss.
I'm up to speed with Excel VBA though so the concepts shouldn't be too alien!
All help appreciated.
Mike
This is most assuredly a novice question, as I'm sure I found a solution to
this before and can't remember it now!
I have two fields, Category and Type, taken from a single table. Each
category has a number of types associated. On the entry form, I've set the
Category field to a SELECT DISTINCT query. What I want to do is get the Type
field to restrict available entries to the relevant Category.
I've got the following query set up:
SELECT Categories.Type
FROM Categories
WHERE (((Categories.Category)=[Forms]![Call Detail Entry Form]![Category]));
This works fine for the first record. However, when a user moves to a new
record, the Types from the first record show up regardless of the Category
selected. The only way to reset it is to close the form completely.
I'm sure this is easy, but as a complete novice to Access VBA I'm at a loss.
I'm up to speed with Excel VBA though so the concepts shouldn't be too alien!
All help appreciated.
Mike