Recent content by Charlie_21

Nope , query open , all fields are empty !

Hi Rich Thanks for your support on this. I save the record, and I go to other records , then back to the one I want to print and all the data is contained on the form. Nothing is coming out on the report , only the column headings.

Yes the form is open, containing data as I have the command button on the form that invokes the report ??

Hi Rich Gettting closer. Now the button works without the input box. However the report hold no data , only the column headings ? This is the SQL generated by adding what you suggested. SELECT Recipes.RecipeID, Recipes.RecipeName, Recipes.Field3, Recipes.Field2, Recipes.Field1...

Hi Rich Done that , as below SELECT * FROM Recipes WHERE [FORMS]![Recipes]![Recipe ID]=Recipes.PrimaryKeyField; Syntax is now correct, however when I run the command button on the form , linked to this query it still bring up an input box Enter Parameter Value Recipes.PrimaryKeyField :confused:

Form printing Hi kbreiss I have made a query as you have outlined. However when I run the query as below I get a syntax error. SELECT * FROM Recipes WHERE [FORMS]![Recipes]![Primary Key Field]=Recipes.Primary Key Field; When I amend it to remove the last .Primary key field; as below...

Hi, Hope someone can help. Think it is a simple question. I have a very small database , where I want to be able to print individual records. Currently using the wizards and the command button options the print option prints all the records held in one table. How do I set it up so when I click...