Settting text box default valure from combo box 1

[jpl458]

Have a table of event names that I want to select into a data entry form and remains there till its changed. I call up the list of events from a combobox (Eventcombo) then after update move the selected event to a text \box with the following:

Me!Text133 = Me!Eventcombo.Column(1)

It puts the correct data in the textbox, but other operation may cause it to be cleared.

I tried to set the textbox defaultvalue using the following

Me!Text133.DefaultValue = Me!Eventcombo.Column(1)

and get #Name.

Any help would be appreciated.

Thanks in advance.

Merry Xmas

jpl

 

[PHV]

Perhaps this ?
Me!Text133.DefaultValue = Chr(34) & Me!Eventcombo.Column(1) & Chr(34)


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

 

[jpl458]

That did the trick. I assume chr(34) is a quote mark.

Thanks

jpl