FAO Howard Brody

  • Thread starter Thread starter Jeremy
  • Start date Start date
J

Jeremy

Re presenting form information

Hi Howard,

Thanks for the help. I have followed instructions but
even though the query I set up is in the format you
suggest I just get a blank field returned where I should
have the name of the selected customer from the database.
Any ideas please?
 
Jeremy,

Base the report on your customer table. Put a button on your form to open the
report. Put this code in the OnClick event of the button:

DoCmd.OpenReport "MyReport",acPreview, "[CustomerID] = " & Me!CustomerID

The report will contain the record of the customer you have on the screen.
 
Back
Top