Combo box help???

[Guest]

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

 

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

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]

 

[Guest]

It's debugging Object invalid or no longer set

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.

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]

 

[John W. Vinson]

It's debugging Object invalid or no longer set

Please post your code.

John W. Vinson [MVP]