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
|
|||
|
|||
Combo box gives '3077' error only on certain records
Hello, I have an Access 97 form that uses a combo box to fill in the rest of the controls on the form. It is based on a query and the query shows all the records, which are checks. However, the form's combo box only shows checks up to 9001147979, and does not see the records with check numbers (text field) that are greater than that. i.e. Though the query shows check #998, the combo box does not. It just gives the 3077 error |
#2
|
|||
|
|||
Combo box gives '3077' error only on certain records
Think I have found the problem....Access combo boxes allow for a maximum of 65535 records, and the combo box I am working on uses a query that returns 66314 records -- mbs4653 ------------------------------------------------------------------------ mbs4653's Profile: http://www.hightechtalks.com/m388 View this thread: http://www.hightechtalks.com/t2296840 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hidden Power of the Combo Box | JethroUK© | New Users | 2 | October 24th, 2005 09:18 AM |
Hidden Power of the Combo Box | JethroUK© | Using Forms | 2 | October 24th, 2005 09:18 AM |
Combo Box Records | JanetF | Using Forms | 1 | June 23rd, 2005 08:58 PM |
Manipulate records of 2 tables | Praveen Manne | Using Forms | 11 | June 14th, 2004 02:41 PM |
Use Combo Box in forms to filter Records in a subform | Rod Burchby | Using Forms | 1 | May 25th, 2004 08:19 PM |