Rest of form will not update

[Guest]

Hi all,

I am trying to design a database from scratch that duplicates some of the
functionality in this database template from Microsoft:
http://office.microsoft.com/en-us/templates/CT011366821033.aspx

In the form "Classes Subform" when you click on a Students Name the rest of
the form is populated.



But when I try to duplicate this form functionality in my Database I am not
able to get the rest of the form to update.



From what I can tell both forms use the same type of source query,
relationship, etc.

Do you have an idea of what I may be missing?
Thanks Steve

 

[Guest]

Hi, Steve.

Do you have an idea of what I may be missing?

Yes. The sample database is using an autolookup query. Ensure that the
query you created for your form's Record Source Property takes StudentID from
the table on the "many" side of the relationship, not from the "one" side.

Also, from the caption, it appears that you are using a lookup field for the
StudentID/StudentName. Lookup fields will cause you grief, so should be
avoided. Please see the following Web page for more information:

http://www.mvps.org/access/lookupfields.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.

Hi all,

I am trying to design a database from scratch that duplicates some of the
functionality in this database template from Microsoft:
http://office.microsoft.com/en-us/templates/CT011366821033.aspx

In the form "Classes Subform" when you click on a Students Name the rest of
the form is populated.



But when I try to duplicate this form functionality in my Database I am not
able to get the rest of the form to update.



From what I can tell both forms use the same type of source query,
relationship, etc.

Do you have an idea of what I may be missing?
Thanks Steve