Form creates unwanted record

B

- 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
 
J

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.
Click to expand...

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]
 
Top