If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Record numbers correspond to subform data not form data
I have a Request form that includes/displays Requested Items in a subform,
whose parent/child relationship is based on an Autonumber. For some reason, unknown to me, the record number displayed in the record navigation bar for the form (not the subform) is based on all the Requested Items in the DB not the number of Requests, as I would expect it to be. I have other, similar forms in the same DB and they don't behave in this odd manner and I can't see any difference in these forms in the properties of the forms or in the table relationships that would cause this to happen. Any help out there? |
#2
|
|||
|
|||
"aavila" wrote in message
I have a Request form that includes/displays Requested Items in a subform, whose parent/child relationship is based on an Autonumber. For some reason, unknown to me, the record number displayed in the record navigation bar for the form (not the subform) is based on all the Requested Items in the DB not the number of Requests, as I would expect it to be. I have other, similar forms in the same DB and they don't behave in this odd manner and I can't see any difference in these forms in the properties of the forms or in the table relationships that would cause this to happen. Any help out there? Are you sure you haven't based the main form on a query that joins the two tables? That would give you as many records as you have Requested Items. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need subform record to = main form record | Narwe | General Discussion | 1 | August 15th, 2004 07:01 AM |
How can I move the focus to a control on a subform? | Brandon | General Discussion | 7 | July 17th, 2004 01:39 AM |
Need help with cascading combos | Tom | Using Forms | 19 | July 1st, 2004 11:11 PM |
synchronizing form and list box | Deb Smith | Using Forms | 8 | June 21st, 2004 08:15 PM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |