Combo Box Missing Records

[TClark14]

I created a form in Access 2007. The Form’s Record Source is tblDrillingDatabase. When I open the table directly (tblDrillingDatabase), all the records are there.. I put a combo box on the form to Find Record based on my selection, which works. My problem is that my combo box does not include all the records from tblDrillingDatabase. I cannot figure this out, probably something goofy I am overlooking. Any help would be appreciated.

COMBO BOX PROPERTIES
EVENT for After Update is:

Private Sub Combo97_AfterUpdate()
' Find the record that matches the control.
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[Well Name] = '" & Me![Combo97] & "'"
If Not rs.EOF Then Me.Bookmark = rs.Bookmark
End Sub

ROW SOURCE is:
SELECT [tblDrillingDatabase].[WELL NAME] FROM [tblDrillingDatabase];

CONTROL SOURCE IS BLANK

 

[Uncle Gizmo]

First of all I must congratulate you on the layout of your question, most helpful.

It seems the me that you are using the combo box to lookup a record to be displayed in the form.

If that's the case, then as you are probably aware there is a wizard for creating a combobox to do that. (One of the selection when you create a combobox with the wizard)

I would suggest using this wizard to create a new combobox and hopefully that will cure the problem.

 

[boblarson]

My problem is that my combo box does not include all the records from tblDrillingDatabase. I cannot figure this out, probably something goofy I am overlooking.

Actually, perhaps they are there, just not where you think they would be as you haven't applied any ordering. Try this

SELECT [tblDrillingDatabase].[WELL NAME] FROM [tblDrillingDatabase] ORDER BY [WELL NAME];

 

[boblarson]

Remember, data within tables are not necessarily stored in the order you input the data. When you pull data from a table you should order it the way you want it to be ordered.

 

[TClark14]

Actually I did use the wizard to create the combo box and I also realized the records were scattered, but unfortunately I am still missing records in the combo box that are definetly in the table. Thanks for the suggestions though. I am at a loss.

 

[boblarson]

Actually I did use the wizard to create the combo box and I also realized the records were scattered, but unfortunately I am still missing records in the combo box that are definetly in the table. Thanks for the suggestions though. I am at a loss.

Can you upload the db? I would like to see this as I don't see how you could be missing records in the combo if they are in the table, given your SQL statement. UNLESS you have more than 1000 records that it is trying to return and your option "Don't Display Lists Where More Than This Number of Records Read:" is set to 1000 and needs to be higher.

 

[TClark14]

Is that in the combo Box properties? I don't recall see that, but I'll look. I do have more than 1000 records.

 

[wazz]

access 2003:
tools-options-edit/find tab

 

[wazz]

btw, i was wondering about that. that option is under a heading called 'Filter by form defaults'. does that apply here?

 

[boblarson]

btw, i was wondering about that. that option is under a heading called 'Filter by form defaults'. does that apply here?

Don't know - it's worth a shot though.

 

[wazz]

yes it is.
i've read the help tooltip (clicking '?') and it seems to have to do with building value lists. i rarely use filter by form so i'm not really sure ...