Get linked control label Caption text

as I keep saying- I am guessing at the actual situation. As others have said - we need more information - either the db or screenshot of the form.

A continuous form usually displays column headings in the header section and are disconnected from the controls below. I suspect the 'object that doesn't exist' is the 'associated label', not the control itself. But who knows without clear information from the OP?. It's taken 15 posts to get from what has been assumed to be a single form to perhaps a continuous form.
 
Sorry

The error in the line:
Code:
If InStr(ctl.Controls(0).Caption, "*") > 0 Then
 
almost certainly because that control does not have an associated label.

you've been asked numerous times to provide more information and have completely ignored those requests so everyone is guessing.
 

Users who are viewing this thread

Back
Top Bottom