Access ComboBox

[LadyRose]

I am trying to access a table with about 5000 records and 150 fields, using a combo box.&nbsp;&nbsp;I can pick the record I want very nicely, but I can't get the rest of the information to show in my form.&nbsp;&nbsp;What do I need to do to get this to work properly.<br><br>I have investigated the Itemdata and ItemIndex, but now that I have captured the information in my primary key, what do I do with it in order to display the record.<br><br>Another idea I have been working with is using the Find feature, but how do I code this so it is more user friendly?<br><br>Any thoughts on this would be very welcome.<br>Thanks, LadyRose

 

[Rubius]

In the combo box properties, set column count to 150....and the row source is a query that you create..but 150 columns is totally nutty buddy!<br><br>

 

[jgarnick]

This is how I get the data to display on my form once I select a record (person) from my combo box.<br><br>Me.RecordsetClone.FindFirst &quot;[ID] = &quot; & Me![Combo138]<br>Me.Bookmark = Me.RecordsetClone.Bookmark<br><br>'[ID] is my primary key.&nbsp;&nbsp;I put this code under the On Change, On exit and On Dblclick properties of the combobox.<br><br>I think it should work for you--good luck! <p>jgarnick<br><a href=mailto:jgarnick@aol.com>jgarnick@aol.com</a><br><a href= > </a><br>

 

[DougP]

Why in the world can't you get the jest of the data record from just a few fields.<br>A combo box is used for getting a record's pointer not gettng the whole record.<br>What are you trying to accomplish here?<br>Also you need to examine your data structure and get a book on normalization to break up those 150 fields into several tables.<br><br>You're data is violating every database rule known to man putting it lightly.<br> <p>DougP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.