subform problem

[Guest]

I have a main form with two subforms. One subform works
fine, but the other is doing something kind of weird. It
is linked to the main form with field "BookID". I have a
combo box in the subform whose source is "TopicID" from
tblTopics. When I enter a book on the main form, I want
to be able to choose various topics this book covers on
the subform and have it save it to tblTopics. It does do
this, however, I've noticed that in some instances,
specifically when I first enter a topic after opening the
form, tblTopics shows a number instead of the topic
name. Every entry after this displays Topic Name though,
until I close the form again.
Any ideas?

Thanks, Tara

 

[Guest]

Forget this post...I just figured out the problem. There
was a space in my rowsource definition that shouldn't
have been there. Not sure why it coused this issue, but
eliminating it fixed the issue.