Combo Boxes on a form

[Kat-ness]

I want to create combo boxes on a form for contacts based on a contacts table where the fields I'm using are not combo boxes such as Name, Address, etc.



I know how to do this initially but I have a few of questions.

1. Is it possible to do a single combo box to pull all of the relevant information at once and have it show on the table? I tried doing this but the cell keeps winding up blank, even after I've selected the record I want to go in there.
2. If I set up individual combo boxes to pull up records separately, i.e. one for first name, one for last name, one for phone number, etc. will this make more sense?
3. When I want to add a new contact record not already in the database, can I just type it into the combo box on the form and have it be saved on my table or is there another way to do this? And if I can do this, will the record be available next time to pull up using the combo box?

[June7]

1. A single combobox can display all related information in the RowSource list. What do you mean by 'have it show on the table'? Only the value of the BoundColumn will save to field set as ControlSource.

2. Only if you want to allow search/filter for any of those values. Review http://datapigtechnologies.com/flash...tomfilter.html

3. Explore the NotInList event http://support.microsoft.com/kb/197526

[Kat-ness]

Thanks for the explanation and the links, June7. Hmm...'Show on the table' is totally not what I was trying to say so I see why that confused you. What I meant was, how do I get all the selected fields in the Rowsource list to show on that, umm...cell?, in my form. I tried putting in about 7 fields and when I selected the record I wanted in the combobox drop down list the cell remained blank??? I tried it with just one field in the rowsource and the record selection appeared in the 'cell'.

[June7]

As to why the selected item would not show in the combobox, would have to know the properties of combobox: RowSource, ControlSource, BoundColumn, ColumnCount, ColumnWidths.

Or provide db for analysis.

[Missinglinq]

Sorry, but to be honest, I'm still confused, but if you want to

• Create a Combobox listing all Contacts
• Select a Contact using a Field that uniquely identifies the Contact
• Have that Contact's Name, Address, Telephone Number, etc., automatically fill in Textboxes on your Form

here's a short example, showing how to do that:

Set up your Combobox using the Wizard and include the Fields you need, from Left-to-Right.

If in the Combobox they appear as

Unique Identifier | Name | Address | Telephone

the code would be

Private Sub YourComboBox_AfterUpdate()
   Me.txtName =  Me.YourComboBox.Column(1)
   Me.txtAddress = Me.YourComboBox.Column(2)
   Me.txtTelephone= Me.YourComboBox.Column(3)
End Sub

The Column Index of a Combobox is Zero-based. The Uniquely Identifying Field, such as an ID field, would be YourComboBox.Column(0) and usually not displayed, merely used to retrieve the data.

The second Field displayed (reading Left-to-Right) would be YourComboBox.Column(1), the third Field would be YourComboBox.Column(2), and so forth.


Linq ;0)>

[Kat-ness]

Thanks for all the help on this. Sorry for the late reply, but it's been a busy week! I definitely appreciate the comments.