How to clear data entries in a Form

[RobFlott]

I have a Form containing several Combo Boxes.
The user opens this form and makes entries based on each of the Combo Boxes.
After they enter all the data they click a button that posts the data into the data table.

The problem occurs when the user returns to that form, and the previous data entries remain,
and I want to clear the entries in each Combo Box.

I tried writing the code below to the OnOpen event for the Form:

Private Sub Form_Open(Cancel As Integer)


Combo94.Value = ""
End Sub

But I get a run-time error (#2448) stating "I can't assign a value to this object"

Can anyone help me on how to 'clear' these pervious selections in each Combo Box?

Thank you,

Rob

[ranman256]

just set them all to ""
Combo94 = ""

DONT use the .VALUE property.

[RobFlott]

Thanks Ranman, I tried your suggestion but still get an error message stating I cannot assign a value to this object.

Private Sub Form_Open(Cancel As Integer)
Combo94 = ""
cboMgr = ""
cboBanner = ""
End Sub

I also tried the following but got the same results:

Private Sub Form_Open(Cancel As Integer)
With Form_frmKPI
Combo94 = ""
cboMgr = ""
cboBanner = ""
End with
End Sub

Is there some other code I need to use that would clear the data appearing in each ComboBox?

[ssanfu]

The problem occurs when the user returns to that form, and the previous data entries remain,

The "previous data entries" remain because the are in the table.
Forms do not "have" data. Forms are a way to view the data stored in a table.


If you have a bound form (sounds like you do), you can set the form to "Data Entry" mode. This allows you to add new records, but cannot view existing records (in that form).

Option two is to move to a new record. either on form open or on a button click.

DoCmd.GoToRecord , , acNewRec

[RobFlott]

Steve, thanks for the quick reply...I'll try these and let you know what happens

Rob

[Missinglinq]

While Steve's advice is probably the way to go (it's how I would do this) the probable cause of the error you got is that the Form_Open event is too early to assign a value to a Control. I suspect that placing this code in the Form_Load event would have worked.

Linq ;0)>

[RobFlott]

Steve, thank you very much...per your suggestion in the 'OpenForm' macro I changed the 'Data Mode' from Edit to Add.