FAO Howard Brody

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

 

[PC Datasheet]

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.