oops...Populating Data Bound Combo Box

[wick77]

On one of the forms in my project i have a data bound Combobox. At run time I want this Combobox to display nothing until the user clicks the arrow. Then I want the Combobox's first listing to be Add New (to add a new record), the second to be a line and then the rest to populated by the relevant field of the recordset. Also how do I check what the user clicked in the on click event so I can Add a new record or go to that selected record.

Any help would be greatly appreciated, thanks,
Wick

[DrewDog_21]

That seems to be going to an awful lot of trouble. Why don't you just put an "Add" button on the form and put the code to add a record to the recordset in the button's CLick event?

Or you could just set the box's Style property to DropDownCombo and then you won't need the button.

[wick77]

Thanks DrewDog_21 :D but thats the way my client would like it. For clarification he wants to be able to pick add new from the combo or an existing name. Clicking add new will open a form so the user can input all the relevant information for that record. I need to know how to populate the Combo like this:

Combo is blank until you click arrow
After arrow click -

Add New
-----------------------------
(Records from pertinent field)

- and how to open the form when Add New is clicked.

I would appreciate more help, thanks,
Wick :)