Form creates unwanted record

[- Butch]

I have a form for a database whereby I can insert criteria and then, by
clicking a "Preview Report" button I can retrieve the information I'm
seeking. The problem is that every time I ask for a report the process also
creates a new record that contains only the information I input into the
form. Somewhere I have an erroneous setting but I can't find where it is.



Thanks in advance for any help.

Butch

 

[John W. Vinson]

I have a form for a database whereby I can insert criteria and then, by
clicking a "Preview Report" button I can retrieve the information I'm
seeking. The problem is that every time I ask for a report the process also
creates a new record that contains only the information I input into the
form. Somewhere I have an erroneous setting but I can't find where it is.

The Form should be UNBOUND - i.e. it should have nothing in its recordsource.
If you're just using to enter criteria for a search, you don't want those
criteria stored anywhere; using a bound form will store them in the table to
which the form is bound.

Just view the form's Properties and blank out the Recordsource property.

John W. Vinson [MVP]