Labels on Form No Longer Preserved.

[KC-Mass]

I have a form that is used to load data from Excel files to Access.
To keep track of what was last loaded I assign the file and path to a label.
The label had been preserved, that is you could load a file; the name of the
file would be assined to a label caption; the form could be closed and
whne you opened it the last caption assigned would still be there. All of a
sudden it now comes up blank when it is closed and the opened.

Any Ideas??

Thx
Kevin

 

[Klatuu]

When you close the form, try this:

Docmd.Close acForm, Me.Name, acSaveYes

 

[KARL DEWEY]

I have a form that is used to load data from Excel files to Access.
How does this work?

 

[KC-Mass]

It uses a TransferSpreadheet to load the data into the first Access table.
From there an access query filters the data and moves it to a standard
table. That works fine. Just the labels are a problem.

Thx

 

[KC-Mass]

It reports that the form, "frmLoad" is not open. It is. ???

Docmd.Save acform, Me!frmLoad also reports "form not open". Again it is and
that is its name.


thx