Open a Report with Criteria from Combo Button

[Jkittle]

I'm trying to use a slection form (F-Select_Shift_Code) to select a date code from a combo box and open a report to show only the criteria slected in the combo box. I've tried variouse ways to do this and can't get it to work.

Can some one see why this isn't working please.

 

[Jkittle]

--------------------------------------------------------------------------------

I'm trying to use a slection form (F-Select_Shift_Code) to select a date code from a combo box and open a report to show only the criteria slected in the combo box. I've tried variouse ways to do this and can't get it to work.

Can some one see why this isn't working please.

Forgot the DB

 

[boblarson]

Just change this line:
DoCmd.OpenReport stDocName, acPreview

to this

DoCmd.OpenReport stDocName, acPreview, , "[ShiftCode]=" & Me.txtshiftcode

 

[Jkittle]

Report Not Returning All Data

Bob,

I changed the DoCmd as suggested but the report does not return all the data with the selected date code.

I though it was the grouping in the report, but after changing that around it didn't make any difference.

Any other suggestions?

Jerry

 

[boblarson]

Bob,

I changed the DoCmd as suggested but the report does not return all the data with the selected date code.

I though it was the grouping in the report, but after changing that around it didn't make any difference.

Any other suggestions?

Jerry

Date code? I thought you were opening by SHIFT CODE.

 

[Jkittle]

Sorry, it is the shift code.

 

[boblarson]

Then, I'm not sure why it isn't working for you. It worked for me in your sample. I'll see if I can post the revised sample when I get to work.

 

[Jkittle]

Thanks for your help Bob

 

[boblarson]

So, are you saying this (see attachment) isn't working right?

 

[Jkittle]

Report Not Working From Combo Box

Bob,

That is correct. The attached Db was not working properly.

The shift code "200804030" has two "our part number" FC3080 and FC3090 but was only returning one. The problem was the way I had the report grouping. So your suggestion worked fine after I fixed the report.

Thank you for your help.