Hi - I have a database that keeps track of training sessions and attendees.
I
have a main form that displays the name of the training session and a
subform
that displays the list of attendees. I haven't had any problems at all
with
the form until yesterday, and have used the form repeatedly in the past to
enter new attendees.
On the attendees subform there is a drop down list indicating attendee IDs
and their names. When a user makes a choice, the ID is stored in the
field.
Yesterday, after selecting an attendee from the list I received the
following
message:
"Object or class does not sup****t the set of events."
After hitting OK, I was able to continue and did not see the message
again.
The record saved properly.
Today, after selecting an attendee from the list, I received this warning:
"Return without GoSub."
After clicking OK, I can continue, but if the form is refreshed, the
record
no longer displays on the form. (Whether I use the "refresh" button, or
whether I go to a different record on the main form and then return to the
record I was just viewing.)
I wasn't sure what it meant, so tried entering another record, but the
same
message appears, and the record does not display after refre****ng the
form.
When I went into the table to enter the record there, all the records I
entered on the form appeared. So, the form is saving the record, just not
displaying it on the subform. After entering another record in the table,
and
returning to the form, the record appears.
Now, I can no longer enter records through the form without getting the
warning. The only thing I can think of that I changed today was how the
drop-down list was sorting, but can't remember if I received the message
before or after changing the sort order of the drop-down list.
The field on the subform where the warning is now showing does have an
embedded macro attached to it, but that is just a MsgBox that will display
a
message if a user enters an attendee ID that does not exist in the
drop-down.
(In case they type an ID, instead of choosing from the drop down.)
Does anyone know why this warning is showing up all of the sudden, and
what
it means? I am not a VBA user, so if it does have something to do with
programming, please use small words. :)
Please let me know if more info is needed.
Thanks for any suggestions on how I can correct my form.
|
