G
Guest
I am looking at a sample database from the Access Inside Out 2002 book. There
are a Books table and an Authors table, with a many to many join through an
intermediate table. The main data entry form populates the Books table. One
field contains a dropdown list of authors. But what if the author has not
been entered yet? The designer placed a subform that allows the user to enter
a new author into the Authors table. I like that, and want to use a similar
feature in my design.
But I noticed that after entering a new author on that subform, the new
entry does not appear in the authors drop down list on the same form unless
the form is closed and reopened. Is that the only way to "refresh" the form
data?
Art
are a Books table and an Authors table, with a many to many join through an
intermediate table. The main data entry form populates the Books table. One
field contains a dropdown list of authors. But what if the author has not
been entered yet? The designer placed a subform that allows the user to enter
a new author into the Authors table. I like that, and want to use a similar
feature in my design.
But I noticed that after entering a new author on that subform, the new
entry does not appear in the authors drop down list on the same form unless
the form is closed and reopened. Is that the only way to "refresh" the form
data?
Art