Form property

[OllieUk]

I am trying to get a field to either be shown or hidden depending on a value of another field when the form opens.

if me.text box.value =“2” then
me.text2.Visible=true


else
me.text2.Visiblefalse

end if

When I run it comes up with a notice “ object not found “

can anyone help

[ranman256]

Use:
me.text2.Visible=Me.text2=“2”

[OllieUk]

Use:
me.text2.Visible=Me.text2=“2”

Have tried this but get Error message
Compile Error
Method or Data member not found (highlight the .Visible =)

My actual original as below

Private Sub AgencyID_AfterUpdate()
If AgencyID.Value = "2" Then
Me.Cost.Visible = True
Else
Me.Cost.Visible = False
End If
End Sub

[Bob Fitz]

Check that you have named the textbox correctly

[OllieUk]

Hi Bob
Yes text box is correctly named

[Bob Fitz]

Can you post a copy of the db to illustrate the problem

[OllieUk]

Sorry cannot post db as comes under data protection

[Bob Fitz]

We don't need to see your real data. Copy the db. Delete any sensitive records from data. Create a couple of dummy records to illustrate the problem.

[Welshgasman]

Sorry cannot post db as comes under data protection

Put it this way.
Access does not suddenly decide not to recognise an object.
It is always that it cannot find the object as the reference or name are incorrect.

When you post it here, a human can recognise the error, Access cannot.

So when it says it cannot find the control, it is telling the truth.

[Micron]

If .Visible is what raises the error, there is something deeper going on. First I'd suggest copying code and pasting in between code tags (use # button on posting toolbar). Don't type it in here for various reasons. Or I'd remove the control, save and close the form and then add the control back again in design view, save, close and reopen.

EDIT

So when it says it cannot find the control, it is telling the truth.

Except the message is about not finding the object OR recognizing a method of the object that it can find.

[Bob Fitz]

While I don't have the knowledge and experience that is abundant in many of the responders here, I have been around long enough to feel confident in saying that whatever is wrong with the db, simply giving us a copy is likely to make solving the problem a whole lot simpler.

[orange]

@ollieUK
As others have said, we need to see the issue in context. If the data is private, then make some dummy data in a copy of the database--enough to show the issue - and post it.

[Welshgasman]

Except the message is about not finding the object OR recognizing a method of the object that it can find.

Method or Data member not found

I took that to mean that either Cost does not have a Visible property/method, or control Cost could not be found on the form it is meant to be on?

[Bob Fitz]

[/COLOR]I took that to mean that either Cost does not have a Visible property/method, or control Cost could not be found on the form it is meant to be on?

Precisely the point I was trying to make earlier. Unless or until the OP posts a copy all anyone can do is guess about what is wrong.

[Gicu]

On top of all the good advice received from everybody that contributed you should probably try without the double quotes if the AgencyID field is numeric (as it should be):

If Me.AgencyID = 2 Then

Cheers,