Compile Error: Method or data member not found

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vy - 29 May 2008 16:40 GMT

I keep getting the error message Compile Error: Method or data member not found
for the following code:

Private Sub Status_AfterUpdate()
Me.Account Status = Null <<< This is where the error message
points to
Me.Account Status.Requery
Me.Account Status = Me.Account Status.ItemData(0)
End Sub

It highlights the .Account
Does anyone have a clue how I could fix this?

Reply to this Message

Douglas J. Steele - 29 May 2008 17:50 GMT

The best way would be to rename Account Status so that it doesn't have a
space in it.

That having been said, it would appear that Account Status is a combo box or
list box. I would think that Access has actually renamed it to
Account_Status internally.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I keep getting the error message Compile Error: Method or data member not
>found
[quoted text clipped - 9 lines]
> It highlights the .Account
> Does anyone have a clue how I could fix this?

Reply to this Message

Jimbo213 - 30 May 2008 01:11 GMT

Doug - I'm getting the same identical error message but I have no spaces

If Me.CompanyBox <> "" And Me.Status <> "" Then << error here
Me.FrameStatusEIA = 25
GoTo CK50
Else:
GoTo BAILOUT
End If

HELP said to check the Count property.
I looked in Locals window and Count is 388 ... what is that?
The CurrentRecord property is 1
The VCR buttons on the form show record 1

Do you have any idea what is causing this compile error?

Signature

Thanks for your reply & assistance.
Jimbo213

> The best way would be to rename Account Status so that it doesn't have a
> space in it.
[quoted text clipped - 16 lines]
> > It highlights the .Account
> > Does anyone have a clue how I could fix this?

Reply to this Message

vy - 30 May 2008 20:52 GMT

Doug you are awesome. Thank you for the help it worked. I put a space in
between and it worked. It compiled.

Reply to this Message