#Deleted being displayed in Text Boxes

[bgreen]

I am having an issue with the word #Deleted being displayed in my text boxes on a form. The form is a data entry form. User enters data on the form which is loaded into an ACCESS table in the same database. When records are all entered by the user a button is pressed which trggers a few events:

A warning window opens (Form). User can choose ok or cancel button. OK triggers a series of events. The data in the table is used to create a file, then the data gets moved to an arcive table. The warning window closes after these events and that is when the #Deleted messages are displayed. How can I make sure that the text boxes are empty when the data entry form becomes active again?

 

[Remou]

A requery of the form should suit.

 

[bgreen]

Where would I put that? How?

 

[Remou]

At the end of the events that are triggered by the button.

Me.Requery

 

[PHV]

Where would I put that? How?
At the very end of the Click event procedure of the button:
Me.Requery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[bgreen]

me.requery won't work. I am using a macro call throug the buttons property window. The macro calls the second form (modal). When you hit ok on the second form it goes through a series of vba commands, then closes. The first form never closes. It sits in the back ground and I guess becomes the active window once the second form is complete. Is there a form_active sub? Or some property I can use?

There are several text boxes, is there an array I can write to set the Values = "" or NULL?

 

[PHV]

I am using a macro call
Use a Click event procedure instead.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886