Clear a Parameter Form

[Huddle]

I have a parameter form I used to enter data for a query. I want it to clear any previous data entered when it opens. I have tried the below without success. I also have the fields defaults set as "" and the form set at yes on data entry.

Private Sub Form_Open(Cancel As Integer)

Me.BldgCmb.Value = ""
Me.StateCmb.Value = ""
Me.CityCmb.Value = ""
Me.AddCmb.Value = ""

End Sub

[pbaldy]

If it's just a parameter form, I wouldn't expect it to be bound to a table, and if it wasn't it would open blank anyway. If you want it bound, you can try the load event instead of the open event, which is too soon to affect data.

[June7]

Agree with Paul, controls on an unbound form would be blank when form opens.

Controls used to input filter parameters should be UNBOUND, otherwise changes data in record.

[Huddle]

It isn't bound to a table but when it opens the previous data is still in the field. Maybe it isn't actually closing. I have it hiding until it runs the query. Actually, when I use it in the report is does come up blank so we're all good. It was just doing it when I was working in the form itself.