Prev: Passing a Control Value from a Form to a Query
Next: FileCopy procedure creating corruption
From: Macka on 8 Dec 2009 00:09
Hi I want to change a label caption and have the form display the new value
next time it is opened. tks Glen
From: Gina Whipp on 8 Dec 2009 00:38
Macka,

It will help to get an answer if you show us the code that makes the caption
change to the new value and tell us which event it is attached to.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Macka" <Macka(a)discussions.microsoft.com> wrote in message
news:6F972B59-297B-4256-9F97-E686BB175573(a)microsoft.com...
> Hi I want to change a label caption and have the form display the new
> value
> next time it is opened. tks Glen


From: Jack Leach dymondjack at hot mail dot on 8 Dec 2009 07:37
You can either set the label on open every time...

Private Sub Form_Open(Cancel As Integer)
Me.LabelName.Caption = "SomeCaption"
End Sub


or if you want you can create a function that opens the form in design mode,
changes the label, saves the form, and closes it...

Public Function SetCaption(strFormName As String, _
strLabelName As String, _
strCaption As String)
DoCmd.OpenForm strFormName, acDesign, , , acHidden
Forms(strFormName).Controls(strLabelName).Caption = strCaption
DoCmd.Close acForm, strFormName, acSaveYes
End Function

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)



"Macka" wrote:

> Hi I want to change a label caption and have the form display the new value
> next time it is opened. tks Glen
 | 
Pages: 1
Prev: Passing a Control Value from a Form to a Query
Next: FileCopy procedure creating corruption