Combo box help???

L

Lime

Hi,
I can not figure out what I am doing wrong here.

I have a query that my table Transplant is used. I have the filed " Week of"
in the second row of the QBE pane and in criteria I have
[Forms]![Trans2]![Combo11] and the show box is unchecked. Now when I open the
from "Trans2" and select a date from the drop down it does not show the
records. I have table source set to the query. I do not know what I am
missing can someone please help.

Lime
 
J

John W. Vinson

Hi,
I can not figure out what I am doing wrong here.

I have a query that my table Transplant is used. I have the filed " Week of"
in the second row of the QBE pane and in criteria I have
[Forms]![Trans2]![Combo11] and the show box is unchecked. Now when I open the
from "Trans2" and select a date from the drop down it does not show the
records. I have table source set to the query. I do not know what I am
missing can someone please help.
Click to expand...

By "table source" do you mean... Recordsource for the form?

If so, you may need to Requery the form in the afterupdate event of
Combo11: click the ... icon by the After update row of the Events tab,
select Code Builder, and edit to

Private Sub Combo11_AfterUpdate()
Me.Requery
End Sub

You should probably first change the name of the combo to something
more meaningful!!

John W. Vinson [MVP]
 
L

Lime

It's debugging Object invalid or no longer set

John W. Vinson said:
Hi,
I can not figure out what I am doing wrong here.

I have a query that my table Transplant is used. I have the filed " Week of"
in the second row of the QBE pane and in criteria I have
[Forms]![Trans2]![Combo11] and the show box is unchecked. Now when I open the
from "Trans2" and select a date from the drop down it does not show the
records. I have table source set to the query. I do not know what I am
missing can someone please help.
Click to expand...

By "table source" do you mean... Recordsource for the form?

If so, you may need to Requery the form in the afterupdate event of
Combo11: click the ... icon by the After update row of the Events tab,
select Code Builder, and edit to

Private Sub Combo11_AfterUpdate()
Me.Requery
End Sub

You should probably first change the name of the combo to something
more meaningful!!

John W. Vinson [MVP]
Click to expand...
 
Top