criteria from form not working

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.

I expect you need to code to Requery the subtopics list on your other form.
--
Duane Hookom
Microsoft Access MVP


"franklinbukoski" wrote:

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.

Do you have code in the after update event of [forms]![startup]![list1] that
will force a requery of the listbox on the SubTopics form?

Something like the following would be needed. Of course, this means that
the SubTopics form would have to be open for this to work without generating
an error.

Private Sub List1_AfterUpdate()
Forms!frmSubTopics!ListSubTopics.Requery
End Sub


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"franklinbukoski" wrote in
message ...
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.

Thank you both very much.

"John Spencer" wrote:

Do you have code in the after update event of [forms]![startup]![list1] that
will force a requery of the listbox on the SubTopics form?

Something like the following would be needed. Of course, this means that
the SubTopics form would have to be open for this to work without generating
an error.

Private Sub List1_AfterUpdate()
Forms!frmSubTopics!ListSubTopics.Requery
End Sub


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"franklinbukoski" wrote in
message ...
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.