If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Form creates unwanted record
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 |
#2
|
|||
|
|||
Form creates unwanted record
On Sat, 24 Mar 2007 10:35:16 -0500, "- Butch" wrote:
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] |
Thread Tools | |
Display Modes | |
|
|