Headline from a listbox

[Vallan]

Hello.


I wonder if this is possible?


I have a form with tabs.

In the first tab i have a listbox. What i want to make is a headline in the form by the value i choose in the listbox.


Thanks for help and i hope i explained well enough.

Matt

 

[Peter Reid]

In the AfterUpdate event of your listbox field, add the following;

Me.Caption = Me.MyListBoxName

where MyListBoxName is the name of your listbox

 

[Vallan]

Thanks for your help.

But it was not quite what i am looking for but i explained a little bad.


I want the headline in a textbox like i show in the word doc.


Matt

 

[Peter Reid]

In that case, the code should look like

Private Sub ListBox1_AfterUpdate()
Me.YourTextBoxName.ControlSource = "='" & Me.YourListBoxName & "'"
End Sub