Trying to refer to control, not control's value

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

Hi all,

I'm about to chew off my arm for this one, because it's
probably pretty simple and I'm just not seeing it or
finding past articles on it...

I want to refer to a control on an open form in order to
requery the control, and I using something very similar
to the example code given in the help. Here is the
example code in MS Access help:

Public Sub RequeryList()

Dim ctlCombo As Control

' Return Control object pointing to a combo box.
Set ctlCombo = Forms!Employees!ReportsTo

' Requery source of data for list box.
ctlCombo.Requery

End Sub

And here is my code:
Dim ctl as Control

Set ctl = Form![frmPatientRecord].Controls
[Me.txtHiddenControl)

ctl.Requery

The only real difference is that I want to refer to a
control that I pass into the current form, so the
Me.txtHiddenControl is a string value that is also the
name of a control on the form frmPatientRecord.

What I keep getting ctl set to is the value of the
control on the open form, not actually the control itself.

What am I not understanding?
 
Public Sub RequeryList()

Dim ctlCombo As Control

' Return Control object pointing to a combo box.
Set ctlCombo = Forms!Employees!ReportsTo

' Requery source of data for list box.
ctlCombo.Requery

End Sub
Click to expand...

Try instead:

Set ctlCombo = Forms!Employees.Controls("ReportsTo")
 
what is Me.txtHiddenControl, is it a textbox?
if it is you want to use txtHiddenControl.Value, or
txtHiddenControl.Text

so your requery statement would be:

Forms!frmPatientRecord.Controls
(Me.txtHiddenControl.Value).Requery
 
Phil said:
Hi all,

I'm about to chew off my arm for this one, because it's
probably pretty simple and I'm just not seeing it or
finding past articles on it...

I want to refer to a control on an open form in order to
requery the control, [snip]

And here is my code:
Dim ctl as Control

Set ctl = Form![frmPatientRecord].Controls
[Me.txtHiddenControl)

ctl.Requery

The only real difference is that I want to refer to a
control that I pass into the current form, so the
Me.txtHiddenControl is a string value that is also the
name of a control on the form frmPatientRecord.
Click to expand...

Use this syntax:

Set ctl =
Forms![frmPatientRecord].Controls(Me.txtHiddenControl)

Note, when posting code to a newsgroup, you should
copy/paste the code you actually have in order to remove
doubts about your typos. E.g. Form!... instead of Forms!..
and the [ balanced by ).
 
Many apologies about the typo, I've been trying a few
things and it begins to get jumbled...

Actually, the code you mention:
Set ctl = Forms![frmPatientRecord].Controls
(Me.txtHiddenControl)

is what I used and still get the value assigned to ctl.

Any other suggestions?
-----Original Message-----
Phil said:
Hi all,

I'm about to chew off my arm for this one, because it's
probably pretty simple and I'm just not seeing it or
finding past articles on it...

I want to refer to a control on an open form in order to
requery the control, [snip]

And here is my code:
Dim ctl as Control

Set ctl = Form![frmPatientRecord].Controls
[Me.txtHiddenControl)

ctl.Requery

The only real difference is that I want to refer to a
control that I pass into the current form, so the
Me.txtHiddenControl is a string value that is also the
name of a control on the form frmPatientRecord.
Click to expand...

Use this syntax:

Forms![frmPatientRecord].Controls(Me.txtHiddenControl)

Note, when posting code to a newsgroup, you should
copy/paste the code you actually have in order to remove
doubts about your typos. E.g. Form!... instead of Forms!..
and the [ balanced by ).
Click to expand...
 
Many apologies about the typo, I've been trying a few
things and it begins to get jumbled...

Actually, the code you mention:
Set ctl = Forms![frmPatientRecord].Controls
(Me.txtHiddenControl)

is what I used and still get the value assigned to ctl.
Click to expand...


That's surprising since ctl is declared to be a control
object and we're Setting it to a control reference.

How do you know that ctl only has a value?
What happens on the
ctl.Requery
line?
--
Marsh
MVP [MS Access]


-----Original Message-----
Phil said:
I'm about to chew off my arm for this one, because it's
probably pretty simple and I'm just not seeing it or
finding past articles on it...

I want to refer to a control on an open form in order
to requery the control, [snip]

And here is my code:
Dim ctl as Control

Set ctl = Form![frmPatientRecord].Controls
[Me.txtHiddenControl)

ctl.Requery

The only real difference is that I want to refer to a
control that I pass into the current form, so the
Me.txtHiddenControl is a string value that is also the
name of a control on the form frmPatientRecord.
Click to expand...
Click to expand...
Marshall said:
Use this syntax:

Forms![frmPatientRecord].Controls(Me.txtHiddenControl)

Note, when posting code to a newsgroup, you should
copy/paste the code you actually have in order to remove
doubts about your typos. E.g. Form!... instead of
Forms!.. and the [ balanced by ).
Click to expand...
Click to expand...
 
Jumping in here, there is no way that this:

dim ctl as control
set ctl = ...

will assign a "value" (not a control) to ctl.

What leads you to say that ctl is getting a "value"?

Remember that the Value property is the default property of a control
object.

So if you do this:

msgbox ctl

you will probably see the value of the control that is referenced by the ctl
variable; but ctl still contains a reference - not a "value".

HTH,
TC


Many apologies about the typo, I've been trying a few
things and it begins to get jumbled...

Actually, the code you mention:
Set ctl = Forms![frmPatientRecord].Controls
(Me.txtHiddenControl)

is what I used and still get the value assigned to ctl.

Any other suggestions?
-----Original Message-----
Phil said:
Hi all,

I'm about to chew off my arm for this one, because it's
probably pretty simple and I'm just not seeing it or
finding past articles on it...

I want to refer to a control on an open form in order to
requery the control, [snip]

And here is my code:
Dim ctl as Control

Set ctl = Form![frmPatientRecord].Controls
[Me.txtHiddenControl)

ctl.Requery

The only real difference is that I want to refer to a
control that I pass into the current form, so the
Me.txtHiddenControl is a string value that is also the
name of a control on the form frmPatientRecord.
Click to expand...

Use this syntax:

Forms![frmPatientRecord].Controls(Me.txtHiddenControl)

Note, when posting code to a newsgroup, you should
copy/paste the code you actually have in order to remove
doubts about your typos. E.g. Form!... instead of Forms!..
and the [ balanced by ).
Click to expand...
Click to expand...
 
Back
Top