Recent content by jlr573

I found the problem. But don't know how to fix it. when i add two fields from a differnet table to the query it doesn't return a recod in the query.

I'm trying to run a query based on the values on a text box in a form, i had this working then i changed something and now it doesn't work and i can't remember what i did to make it stop working. Private Sub cmdJobCompleteButton_Click() Me.Visible = False DoCmd.OpenQuery...

Thanks this works great! I do have another question though. How do i get the code to print the report "rptMaterialSheet" once it opens and also print the report that the Command30 button is on?

I'm trying to open a dialog box using VB code and the vbyesnocancel i want a report to open when the user clicks yes and when they click no i want to go head a print the report they are on. Private Sub Command30_Click() MsgBox ("Would You Like To Attach a Material Sheet?"), vbYesNoCancel If...