Search Form Adds a New Record "DB via AccessMonster.com" <u47072[ at ]uwe> 11/10/2008 4:48:47 PM I just created a search form (very basic) that I linked to Query Criteria, when i put the number into the text box and hit enter, it auotmatically updates the subform in the same form. I really like just hitting enter, and getting results, but the problem is that it adds a record of whatever I have typed into the text box. What can I do to fix this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1

Re: Search Form Adds a New Record "bassstuf via AccessMonster.com" <u47072[ at ]uwe> 11/10/2008 4:56:58 PM ---Closed--- DB wrote: [Quoted Text] >I just created a search form (very basic) that I linked to Query Criteria, >when i put the number into the text box and hit enter, it auotmatically >updates the subform in the same form. I really like just hitting enter, and >getting results, but the problem is that it adds a record of whatever I have >typed into the text box. What can I do to fix this. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1