I have a form on which there are several combo boxes. The operator can select various options from these combo boxes, the options selected are used in an SQL statement which is then used for the record source of a sub form within this form.
I also use the same SQL statement as the row source for a report so that I can print out the sub form information easily.
However I now want to distribute the database in the MDE format. And I get the following error:
you can't set the record source property after the printing has started
I understand this is caused because changes cannot be made to reports in an M. D. E. database.
I believe the solution is to use the SQL statement to create a query, and then used that query as the row source for the report. I have done this before, but before I make this modification, are there any other ways that I have overlooked?
Any comment, advice gratefully received.