criteria from form not working

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
..
 
Thank you both very much.

John Spencer said:
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 said:
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.
Click to expand...
Click to expand...
 
Back
Top