Printing one record on a report

[thalam]

Hi there,

I'm sure there is a simple command that needs to get written. But basically I am trying to print the current record that is open in a report. Its right now printing all the records into the report. I'm sure its just some parameter I need to type into the print command line, but I can't seem to get it.

If anyone has any ideas, it would be greatly appreciated.

Thanks

 

[QTNM]

what do you mean by, "to print the current record that is open in a report".

If you have the record open on a form, then set the recordsource of your report to retrieve the record via an id ( preferably your primary key) from your form.

Hope that helps. I'm only going on the info you have supplied.

QT = )

 

[thalam]

Thanks!

What your saying makes sense to me. I just gotta find the syntax to specify the record source I guess.

Another issue I am having, which is somewhat related to this is that, when I add a new record for the same customer (i.e., have the customer in there twice for different incidences) the database when it makes the report puts both records on one page. Any ideas on how to have just one record per page, even if there r multiple incidences of the same customer?