G
Guest
The following is a sql view of my query:
SELECT Subtopics.Subtopics
FROM [S1 Net Topics] INNER JOIN Subtopics ON [S1 Net Topics].[Topic ID] =
Subtopics.[Topics ID]
WHERE ((([S1 Net Topics].Topic)=[forms]![startup]![list1]));
when I click on an item in a listbox on a form called Startup, I want all of
the subtopics to show up in another form (in a listbox) called Subtopics.
The criteria i set is not prompting a filter action though. I had it working
but can't reproduce the desired results.
SELECT Subtopics.Subtopics
FROM [S1 Net Topics] INNER JOIN Subtopics ON [S1 Net Topics].[Topic ID] =
Subtopics.[Topics ID]
WHERE ((([S1 Net Topics].Topic)=[forms]![startup]![list1]));
when I click on an item in a listbox on a form called Startup, I want all of
the subtopics to show up in another form (in a listbox) called Subtopics.
The criteria i set is not prompting a filter action though. I had it working
but can't reproduce the desired results.