Bound text box in a form to display empty when opened

[Shamli]

Hello Everyone



I have few text boxes they are all bound to a table in a form. But whenever I open the form, I don't want them to hold the previous values. I want the textboxes to be empty.
I have tried keeping this code in the onload form

Me.Textbox1.value = ""

But its not working.


Can anyone help me with this.

[pbaldy]

If you want to add new records, open the record in data entry mode (an argument of OpenForm).

[Shamli]

Thank you for replying.
The data entry mode is set to yes in the form.



The form opens with bound valued textboxes but once the users enters the input, it saves into another table.
and the next time when form is opened, I don't want text box holding previous values.
I am not keeping the unbound because the form is a continuous form.
And many new records are added to it.

If you want to add new records, open the record in data entry mode (an argument of OpenForm).

[pbaldy]

I'm confused. If the form is in data entry mode, it should not show any existing records. Are you sure it's not a default value that's displaying? Can you attach the db here?

[Shamli]

Hi. Sorry for updating the answer late. I found a solution as soon as I read your reply. I don't know why that happens every time .Thank you so much for giving me hints all the time.

Below is the code I used.

On Error Resume Next
 With Me.RecordsetClone
 .MoveFirst
 Do While .EOF = False
 .Edit
 .Fields("CarID").Value = ""
 .Fields("Origination").Value = ""
 .Fields("Destination").Value = ""
 .Fields("Purpose").Value = ""
 .Fields("Total Miles").Value = ""
 
 .Update
 .MoveNext
 Loop
 End With
 
 Application.SetOption "Confirm Action Queries", 0

I'm confused. If the form is in data entry mode, it should not show any existing records. Are you sure it's not a default value that's displaying? Can you attach the db here?

[pbaldy]

Glad you got it working.