Rin Time error 2465

  • Thread starter Thread starter jtbleek
  • Start date Start date
J

jtbleek

"Microsoft Office Access can't find the field 'cboMovieLookup' referred to in
you expression."

I have a subform that I am attempting to add a combo box that lists the
movie ID and when the user clicks on the movie ID it will fill in info like
the Movie Title in a text box. I've doen this on the main form using similar
code and it worked fine, but it is not working now and getting the Run tim
error 2465. I have a feeling it has to do with naming conventions but not
sure.

Private Sub cboMovieLookup_AfterUpdate()

Me.VideoTitle = DLookup("[VideoTitle]", "tblVideos",
"[VideoID]=[Forms]![Rent Movie].[cboMovieLookup]")

End Sub

So the way I understand this code is in that it looks up the Video Title
from the form Rent Movie where VideoID matches the selection made in the
cboMovieLookup combo box.

Any help would be appreciated.
 
On Thu, 4 Dec 2008 18:07:00 -0800, jtbleek

I'm guessing all the control names you mentioned are in your subform,
and [Rent Movie] is the name of your subform.
If so, it don't work that way, because the syntax to access a subform
control is more complicated than that:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

But fortunately this works as well in your case (if my assumption is
true):
Me.VideoTitle = DLookup("VideoTitle", "tblVideos",
"VideoID=" & Me.cboMovieLookup)

-Tom.
Microsoft Access MVP
 
That works great, but I've run into one other problem. I want the form to be
able to show more then one movie but I use the combo box to enter in the
movie info, but then when I add another record it uses the same value in the
combo box on the line above. If I change it it changes the information on the
first movie. Is there a way for each record in the subform to be unique?
Sorry if it confusing.

Tom van Stiphout said:
On Thu, 4 Dec 2008 18:07:00 -0800, jtbleek

I'm guessing all the control names you mentioned are in your subform,
and [Rent Movie] is the name of your subform.
If so, it don't work that way, because the syntax to access a subform
control is more complicated than that:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

But fortunately this works as well in your case (if my assumption is
true):
Me.VideoTitle = DLookup("VideoTitle", "tblVideos",
"VideoID=" & Me.cboMovieLookup)

-Tom.
Microsoft Access MVP

"Microsoft Office Access can't find the field 'cboMovieLookup' referred to in
you expression."

I have a subform that I am attempting to add a combo box that lists the
movie ID and when the user clicks on the movie ID it will fill in info like
the Movie Title in a text box. I've doen this on the main form using similar
code and it worked fine, but it is not working now and getting the Run tim
error 2465. I have a feeling it has to do with naming conventions but not
sure.

Private Sub cboMovieLookup_AfterUpdate()

Me.VideoTitle = DLookup("[VideoTitle]", "tblVideos",
"[VideoID]=[Forms]![Rent Movie].[cboMovieLookup]")

End Sub

So the way I understand this code is in that it looks up the Video Title
from the form Rent Movie where VideoID matches the selection made in the
cboMovieLookup combo box.

Any help would be appreciated.
Click to expand...
Click to expand...
 
On Thu, 4 Dec 2008 18:49:00 -0800, jtbleek

I think I know what you mean. This happens in a subform if the control
is not bound (to a table, query). Bind it, to a temp table if you
must, and you shall be victorious.

-Tom.
Microsoft Access MVP

That works great, but I've run into one other problem. I want the form to be
able to show more then one movie but I use the combo box to enter in the
movie info, but then when I add another record it uses the same value in the
combo box on the line above. If I change it it changes the information on the
first movie. Is there a way for each record in the subform to be unique?
Sorry if it confusing.

Tom van Stiphout said:
On Thu, 4 Dec 2008 18:07:00 -0800, jtbleek

I'm guessing all the control names you mentioned are in your subform,
and [Rent Movie] is the name of your subform.
If so, it don't work that way, because the syntax to access a subform
control is more complicated than that:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

But fortunately this works as well in your case (if my assumption is
true):
Me.VideoTitle = DLookup("VideoTitle", "tblVideos",
"VideoID=" & Me.cboMovieLookup)

-Tom.
Microsoft Access MVP

"Microsoft Office Access can't find the field 'cboMovieLookup' referred to in
you expression."

I have a subform that I am attempting to add a combo box that lists the
movie ID and when the user clicks on the movie ID it will fill in info like
the Movie Title in a text box. I've doen this on the main form using similar
code and it worked fine, but it is not working now and getting the Run tim
error 2465. I have a feeling it has to do with naming conventions but not
sure.

Private Sub cboMovieLookup_AfterUpdate()

Me.VideoTitle = DLookup("[VideoTitle]", "tblVideos",
"[VideoID]=[Forms]![Rent Movie].[cboMovieLookup]")

End Sub

So the way I understand this code is in that it looks up the Video Title
from the form Rent Movie where VideoID matches the selection made in the
cboMovieLookup combo box.

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Pardon my ignorance, but I am not sure what you mean. Isn't the combo box
already to my primary key? How would I do what you are saying?


Tom van Stiphout said:
On Thu, 4 Dec 2008 18:49:00 -0800, jtbleek

I think I know what you mean. This happens in a subform if the control
is not bound (to a table, query). Bind it, to a temp table if you
must, and you shall be victorious.

-Tom.
Microsoft Access MVP

That works great, but I've run into one other problem. I want the form to be
able to show more then one movie but I use the combo box to enter in the
movie info, but then when I add another record it uses the same value in the
combo box on the line above. If I change it it changes the information on the
first movie. Is there a way for each record in the subform to be unique?
Sorry if it confusing.

Tom van Stiphout said:
On Thu, 4 Dec 2008 18:07:00 -0800, jtbleek

I'm guessing all the control names you mentioned are in your subform,
and [Rent Movie] is the name of your subform.
If so, it don't work that way, because the syntax to access a subform
control is more complicated than that:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

But fortunately this works as well in your case (if my assumption is
true):
Me.VideoTitle = DLookup("VideoTitle", "tblVideos",
"VideoID=" & Me.cboMovieLookup)

-Tom.
Microsoft Access MVP


"Microsoft Office Access can't find the field 'cboMovieLookup' referred to in
you expression."

I have a subform that I am attempting to add a combo box that lists the
movie ID and when the user clicks on the movie ID it will fill in info like
the Movie Title in a text box. I've doen this on the main form using similar
code and it worked fine, but it is not working now and getting the Run tim
error 2465. I have a feeling it has to do with naming conventions but not
sure.

Private Sub cboMovieLookup_AfterUpdate()

Me.VideoTitle = DLookup("[VideoTitle]", "tblVideos",
"[VideoID]=[Forms]![Rent Movie].[cboMovieLookup]")

End Sub

So the way I understand this code is in that it looks up the Video Title
from the form Rent Movie where VideoID matches the selection made in the
cboMovieLookup combo box.

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
On Thu, 4 Dec 2008 23:59:00 -0800, jtbleek

Your combobox has a rowsource, but it must also have a ControlSource.
-Tom.
Pardon my ignorance, but I am not sure what you mean. Isn't the combo box
already to my primary key? How would I do what you are saying?


Tom van Stiphout said:
On Thu, 4 Dec 2008 18:49:00 -0800, jtbleek

I think I know what you mean. This happens in a subform if the control
is not bound (to a table, query). Bind it, to a temp table if you
must, and you shall be victorious.

-Tom.
Microsoft Access MVP

That works great, but I've run into one other problem. I want the form to be
able to show more then one movie but I use the combo box to enter in the
movie info, but then when I add another record it uses the same value in the
combo box on the line above. If I change it it changes the information on the
first movie. Is there a way for each record in the subform to be unique?
Sorry if it confusing.

:

On Thu, 4 Dec 2008 18:07:00 -0800, jtbleek

I'm guessing all the control names you mentioned are in your subform,
and [Rent Movie] is the name of your subform.
If so, it don't work that way, because the syntax to access a subform
control is more complicated than that:
Forms!YourMainForm!YourSubformControlName.Form!YourControlNameOnSubform

But fortunately this works as well in your case (if my assumption is
true):
Me.VideoTitle = DLookup("VideoTitle", "tblVideos",
"VideoID=" & Me.cboMovieLookup)

-Tom.
Microsoft Access MVP


"Microsoft Office Access can't find the field 'cboMovieLookup' referred to in
you expression."

I have a subform that I am attempting to add a combo box that lists the
movie ID and when the user clicks on the movie ID it will fill in info like
the Movie Title in a text box. I've doen this on the main form using similar
code and it worked fine, but it is not working now and getting the Run tim
error 2465. I have a feeling it has to do with naming conventions but not
sure.

Private Sub cboMovieLookup_AfterUpdate()

Me.VideoTitle = DLookup("[VideoTitle]", "tblVideos",
"[VideoID]=[Forms]![Rent Movie].[cboMovieLookup]")

End Sub

So the way I understand this code is in that it looks up the Video Title
from the form Rent Movie where VideoID matches the selection made in the
cboMovieLookup combo box.

Any help would be appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top