requery for drop-downlist in sub-form

B

Bob Richardson

My Form works some of the time. Why not always? It's a bit envoled, so let
me explain.

My student data entry/edit form uses TABS to access different types of data
for the student. Clicking on the "Conference" TAB brings up the conference
sub-form for the last year that the current student attended a conference. A
standard nav bar can get information from other years that this student
attended conferences. If this student has never attended a conference, then
a blank form appears for the most recent year.

Each student/conf form has three drop-down lists with the Course(s) attended
at the conference.

The drop down lists for a year are populated from a tCourse table. For
example:
YEAR COURSE
2002 Programming 1
2002 Programming 2
2002 Database design
2002 Word
2003 Programming 1
2003 Spreadsheets 1
2003 Word
2003 Basic
2003 C++
2004 Programming 1
2004 Photoshop
2004 Spreadsheets 2
2004 Basic
2004 C++

To fill the drop-down lists I've set the following data properties for each
drop-down list:
row source type : table/query
row source: SELECT tCourse.Course
my query builder Shows
field COURSE YEAR
table tCourse tCourse
sort Ascending
criteria: [DataConference].[Year]

Bound Column: 1
Limit to List: yes


I have coded a Subroutine

Private Sub RedoQ()
Me.Course1.Requery
Me.Course2.Requery
Me.Course3.Requery
End Sub

I run the Subroutine on the Form's "on Current" and "on activate" events,
and this works when a Conf record exits for the student. BUT, when there is
no record, I want the drop-down list to be populated with the current year's
Course Options. HELP!
 
Top