Combo Box

[Guest]

I have a command button that opens a second form in dialog mode and allows
the user to add a new contact , first name, last name and phone numbers. The
contactid is automatically assigned and the CompanyCode from the main form
that the contact is associated with is also stored. The first and last name
are concatenated and the contactid and name are added to the combo box
listing of the first form. Everything works fine but then the user has to go
to the combo box and select the newly added contact. I'd like the newly
added name and it's info to automatically appear.

My second question is this. When the contact information is displayed on
the main form I'm unable to edit the phone numbers.

contactid=id
contactid.Column(1)= name
contactid.Column(2)= phone
-

 

[Guest]

Try requery on the combo box. Me.cboComboBox.Requery

 

[Bob Quintal]

I have a command button that opens a second form in dialog mode
and allows the user to add a new contact , first name, last name
and phone numbers. The contactid is automatically assigned and the
CompanyCode from the main form that the contact is associated with
is also stored. The first and last name are concatenated and the
contactid and name are added to the combo box listing of the first
form. Everything works fine but then the user has to go to the
combo box and select the newly added contact. I'd like the newly
added name and it's info to automatically appear.

After requering the combobox so that the new value is available, set
the combo box.value = whatever is the concatenation of the new
record.

My second question is this. When the contact information is
displayed on the main form I'm unable to edit the phone numbers.

contactid=id
contactid.Column(1)= name
contactid.Column(2)= phone
-

Values via a combobox.column() are read-only. Only hte bound column
can be edited.

 

[Guest]

The last line of my command button is requery. The name is added to the
combo box list but I have to manually go back to the combo box and select the
contact I just entered. I wanted to eliminate that step by automatically
having the new contact and it's info displayed on the main form. I hope I'm
making this clear.