Combo box with 4 columns

[spcepickle]

Hey All - I have a combo box that reads from a table and has 4 columns. The name of the contractor, phone 1, phone 2 and fax. When you select a contractor the phone and fax numbers show up in their own text box. I also have a notinlist command that allows the user to add a new contractor.

The problem how do they add the phone and fax numbers for the new entry?

Thanks!
~Amelia

 

[mlai08]

For new contractor, you can trigger off opening of a form based on the table to allow user to enter phone, fax etc.

Mike

 

[namliam]

They dont... or not in the combobox...

The way you should (try to?) make this work is:
The On Not in list event:
Open a popup form in "add" modus. Possibly sending the name to that popup form using the "OpenArgs"
Then have the users enter all the columns on that popup form.
Now requery your combobox, and the new entry should be available for picking

 

[spcepickle]

I used Method 2 as shown here.

Thanks for all the suggestions.

~Amelia

 

[spcepickle]

Opps I should also post the link:
http://support.microsoft.com/kb/197526

 

[namliam]

as long as it works for you