Compile Error: Method or data member not found

V

vy

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?
 
D

Douglas J. Steele

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.
 
J

Jimbo213

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?
 
V

vy

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top