Code

[weastm7]

Hello,

I am trying to make an mde file. Access is unable to make the file. I Alt
F11 to debug/compile and it highlights the ".disposition_choice_afterupdate"
portion of the following.

Private Sub level_2_choice()
Me.disposition_choice_afterupdate.Requery
End Sub
End Sub

What is Access telling me to correct?

 

[Guest]

The way you have it coded is suspicious. disposition_choice_afterupdate looks
like the After Update event of a control named disposition_choice, but your
code is treating it as if it is the name of a control. You can requery a
control, but not a sub or function.

It would be helpful if you posted the error number and description as well
as the line where the error occurred.

 

[weastm7]

All I see is line 62, col. 34, "compile error: method or data member not
found"

The way you have it coded is suspicious. disposition_choice_afterupdate looks
like the After Update event of a control named disposition_choice, but your
code is treating it as if it is the name of a control. You can requery a
control, but not a sub or function.

It would be helpful if you posted the error number and description as well
as the line where the error occurred.

Hello,

[quoted text clipped - 8 lines]

What is Access telling me to correct?

 

[Guest]

Okay,
So what is disposition_choice_afterupdate? Is it a sub?
Is disposition_choice the name of a control?
What are you trying to do?
--
Dave Hargis, Microsoft Access MVP

All I see is line 62, col. 34, "compile error: method or data member not
found"

The way you have it coded is suspicious. disposition_choice_afterupdate looks
like the After Update event of a control named disposition_choice, but your
code is treating it as if it is the name of a control. You can requery a
control, but not a sub or function.

It would be helpful if you posted the error number and description as well
as the line where the error occurred.

Hello,

[quoted text clipped - 8 lines]

What is Access telling me to correct?

 

[Mr. B]

Okay,
So what is disposition_choice_afterupdate? Is it a sub?
Is disposition_choice the name of a control?
What are you trying to do?
--
Dave Hargis, Microsoft Access MVP

All I see is line 62, col. 34, "compile error: method or data member not
found"

The way you have it coded is suspicious. disposition_choice_afterupdate looks
like the After Update event of a control named disposition_choice, but your
code is treating it as if it is the name of a control. You can requery a
control, but not a sub or function.
It would be helpful if you posted the error number and description as well
as the line where the error occurred.
Hello,
[quoted text clipped - 8 lines]
What is Access telling me to correct?- Hide quoted text -

- Show quoted text -

The code you are referencing might be code that was left over when you
deleted an existing control on your form.

Do you still have the control "disposition_choice" on your form. If
not, just delete the code. If you have code in an event of a control
and delete the control, Access will leave the code. It will not cause
a problem until you try to create the mde.

HTH

Mr. B

 

[weastm7]

I am working on a form for engineering service requests. I have a combo box
listing "first level disposition" such as setup, tooling, program. I have
four more combo boxes listing "second level" for each of the "first level"
choices.

I have not added any subforms and the "properties" page does not have
anything marked in the afterupdate row.

This is one of the first projects I've worked on in Access. I am not
familiar with coding and hoping I interpret/respond reasonably.

Okay,
So what is disposition_choice_afterupdate? Is it a sub?
Is disposition_choice the name of a control?
What are you trying to do?

All I see is line 62, col. 34, "compile error: method or data member not
found"

[quoted text clipped - 11 lines]

 

[Guest]

In design veiw, look at your form.
Is there a control named disposition_choice?
Open the properties dialog for the control. Choose the events tab. Is
there anything in the event After UpDate?

--
Dave Hargis, Microsoft Access MVP

I am working on a form for engineering service requests. I have a combo box
listing "first level disposition" such as setup, tooling, program. I have
four more combo boxes listing "second level" for each of the "first level"
choices.

I have not added any subforms and the "properties" page does not have
anything marked in the afterupdate row.

This is one of the first projects I've worked on in Access. I am not
familiar with coding and hoping I interpret/respond reasonably.

Okay,
So what is disposition_choice_afterupdate? Is it a sub?
Is disposition_choice the name of a control?
What are you trying to do?

All I see is line 62, col. 34, "compile error: method or data member not
found"

[quoted text clipped - 11 lines]

What is Access telling me to correct?

 

[weastm7]

I looked at all 5 controls and none have anything in the event After UpDate.

In design veiw, look at your form.
Is there a control named disposition_choice?
Open the properties dialog for the control. Choose the events tab. Is
there anything in the event After UpDate?

I am working on a form for engineering service requests. I have a combo box
listing "first level disposition" such as setup, tooling, program. I have

[quoted text clipped - 16 lines]

 

[Guest]

I can't help you if you don't answer my questions. Go back to my previous
post and answer both questions, please.
--
Dave Hargis, Microsoft Access MVP

I looked at all 5 controls and none have anything in the event After UpDate.

In design veiw, look at your form.
Is there a control named disposition_choice?
Open the properties dialog for the control. Choose the events tab. Is
there anything in the event After UpDate?

I am working on a form for engineering service requests. I have a combo box
listing "first level disposition" such as setup, tooling, program. I have

[quoted text clipped - 16 lines]

What is Access telling me to correct?

 

[weastm7]

I'm sorry about that. I have a control box named "disposition" but not
"disposition_choice" and no event After UpDate in the "disposition" control.

I can't help you if you don't answer my questions. Go back to my previous
post and answer both questions, please.

I looked at all 5 controls and none have anything in the event After UpDate.

[quoted text clipped - 8 lines]

 

[Guest]

ok, thanks.
Is disposition a text box? If not, what kind of control is it?
Also, what is it you are trying to do?

The original code:

Private Sub level_2_choice()
Me.disposition_choice_afterupdate.Requery
End Sub
End Sub


First, there should be only 1 End Sub
Is the sub called anywhere? Do you find any code that references
level_2_choice()

Ususally, the only types of controls you requery are list boxes and combo
boxes because they often use tables or queries for their data.
So I don' know what the goal is to be able to help.
Can you explain what is going on and what you want?
--
Dave Hargis, Microsoft Access MVP

I'm sorry about that. I have a control box named "disposition" but not
"disposition_choice" and no event After UpDate in the "disposition" control.

I can't help you if you don't answer my questions. Go back to my previous
post and answer both questions, please.

I looked at all 5 controls and none have anything in the event After UpDate.

[quoted text clipped - 8 lines]

What is Access telling me to correct?

 

[weastm7 via AccessMonster.com]

There was no "disposition_choice" on my form so I deleted the code as
suggested by Mr. B.

I am able to make an mde file, but now it's picking up data from another
table. Why would my mbd reference everything correctly (form and data), but
does not when I make an mde?

ok, thanks.
Is disposition a text box? If not, what kind of control is it?
Also, what is it you are trying to do?

The original code:

Private Sub level_2_choice()
Me.disposition_choice_afterupdate.Requery
End Sub
End Sub

First, there should be only 1 End Sub
Is the sub called anywhere? Do you find any code that references
level_2_choice()

Ususally, the only types of controls you requery are list boxes and combo
boxes because they often use tables or queries for their data.
So I don' know what the goal is to be able to help.
Can you explain what is going on and what you want?

I'm sorry about that. I have a control box named "disposition" but not
"disposition_choice" and no event After UpDate in the "disposition" control.

[quoted text clipped - 6 lines]