Connecting Tech Pros Worldwide Forums | Help | Site Map

Form/Subform - Navigation in Access 2003

Newbie
 
Join Date: Sep 2006
Posts: 1
#1: Sep 4 '06
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

msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,880
#2: Sep 5 '06

re: Form/Subform - Navigation in Access 2003


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.

Quote:

Originally Posted by RLC603

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

Reply