Force Combobox to go to new record

[Phred]

Access 2007, not compiled, not split, Windows 7, Moderately Skilled



I have a Combobox at the top of my Vendor form. You pick the Vendor Name from the box and it displays the Vendor information below.

I have a command button on my main form "Add New Vendor" - On Click:

DoCmd.GoToRecord , , acNewRec (The form fields clear and are ready to recieve new vendor info.)

But the combo box, at the top, still retains the previous Customers Name. I would like to force the combo box to go to a new record as well.

MyComboBoxName docmd.gotorecord, , acNewRec (code I would like to add but don't know how.)

MsgBox "Enter Vendor name and data.", vbOKOnly, "Enter New Vendor"
Forms![frm_main]![SubFrm_Vendors]!VendorName.SetFocus

After the new Vendor Name is entered, the new record saves and the form refreshes to the new Vendor on the form and in the Combo Box.

In VBA is there a way to reference a specific control, on a form (combobox), and force it to a new record?

PHred

[Bob Fitz]

After:
MyComboBoxName docmd.gotorecord, , acNewRec

Try adding this line:
MyComboBoxName = 0

[John_G]

Generally speaking, combo boxes are used to select data, not add to it. Is the combo box bound to a field in your form's record source (probably not, if it retains the name)? If not, than you cannot use it to add data to your vendors table. Combo boxes cannot "go to a new record" in any case - they can only update the current record, and only the field they are bound to, if any.

HTH

John

[Phred]

That did it!

I have been trying everything.

I did me.comboboxname = "" (You don't ever want to do this one it disappears the Row Source SQL statement It took me forever to figure that out. And only because June7 told me.)

But the = 0 doesn't seem to cause any problems. I'm curious to know why?

But in any event thanks so much. I will be using this several places. Such a simple solution.

I will mark this solved. Have a great weekend.

Phred