Access 2000 control name stored in new form

[Mike Ryan]

How can I store a combo box control's name in a field of a new form opened
by the double click property of the original control

 

[Chris Roth [MVP]]

Hi Mike,

txtBox.Text = cmbBox.Name ???

or are you trying to write some info to a Visio shape? I don't fully
understand...do you have a vb controls on a Visio page?

--
Hope this helps,

Chris Roth
Visio MVP

Free Visio shapes:
http://www.visguy.com/category/shapes
Visio programming info:
http://www.visguy.com/category/programming/
Other Visio resources:
http://www.visguy.com/visio-links/

 

[Mike Ryan]

Hi Chris,
I'm not working in Visio, so what you suggested doesn't work - but thanks
anyway.

What I'm doing is below:
DoCmd.OpenForm "frmCmnt"
DoCmd.GoToRecord , , acNewRec
Forms!frmcmnt!Service = Me.Service
Forms!frmcmnt!question = "A_ComWithin"

What I want to do is set the question field on the form frmcmnt to the name
of the combo box on which I double clicked. This is the way I have done it
currently but I have to have this code for all 128 questions on the form! I
was hoping there was a more elegant solution.

Mike