By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

Form/Subform - Navigation in Access 2003

P: 1
I have a form with subform which details documents within a contract and data
elements within the documents. The form contains info. about the contract
and one or several documents associated with the contract based on
section_id. The form displays only one document at a time. The subform
contains data elements associated with a contracts documents based on
section_id.

Using the form navigation bar, or code associated with a record navigation
object, I want to scroll forward and back through the documents associated
with a contract. Currently when I use the form records navigation bar it
scrolls through all the records (data elements) associated with a document
before moving to the next doucment.

RLC603
Sep 4 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
Your subform needs to be tied to the document ID in the parent form rather than the section ID which I assume is not unique to the document.

I have a form with subform which details documents within a contract and data
elements within the documents. The form contains info. about the contract
and one or several documents associated with the contract based on
section_id. The form displays only one document at a time. The subform
contains data elements associated with a contracts documents based on
section_id.

Using the form navigation bar, or code associated with a record navigation
object, I want to scroll forward and back through the documents associated
with a contract. Currently when I use the form records navigation bar it
scrolls through all the records (data elements) associated with a document
before moving to the next doucment.

RLC603
Sep 4 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.