Tammysdatabase
Member
- Local time
- Today, 07:41
- Joined
- Mar 18, 2020
- Messages
- 34
I've made a purchase order system and am having trouble with a subform. My main form (Single Form) is unbound and has comboboxes set up to filter the subform. The subform displays as a datasheet. This works great except for one problem. My PODetail table has 17,000 records in it and the subform will not display all the records, particularly the older records. I first thought that maybe there is a limit on the datasheet view, but the first record that shows is "2" and then the next is "4562", then it jumps to "4694". This is before i even touch the comboboxes on the main form so just on open. You would think the subform should display all the records on the table, no? I have exported the table to excel to see if I could figure out what might be happening, but there is no rhyme or reason for this as far as I can see.
The main form's Filter on Load property is set to "No". The Filter property is blank.
The subform's Filter on Load is set to "No". The Filter property is blank. I do have this form's Order By property set to the PO number in descending order.
When I try to filter the data say by SKU, i'll get 6 out of the 17 records that should show up.
Any thoughts? I'm sure I'm just missing something stupid.
The main form's Filter on Load property is set to "No". The Filter property is blank.
The subform's Filter on Load is set to "No". The Filter property is blank. I do have this form's Order By property set to the PO number in descending order.
When I try to filter the data say by SKU, i'll get 6 out of the 17 records that should show up.
Any thoughts? I'm sure I'm just missing something stupid.