Access form question

95five-0 · 11-05-2007, 10:57 AM

I have no idea why I con't figure this out but it is drving me crazy. I have created a table that has two fields. One that is the ID that numbers the entries and another for text. I am trying to create a form that will allow me to open it enter the text for that field and have it added to the bottom of the table. But for some reason everytime I reopen the form it jus starts over writting everything that was added before. Does anyone know a way to tell it to create a new row everytime?

Thanks.

Chevy · 11-08-2007, 03:24 AM

The form is opening at the beginning. If you can view the code for the form, look for:

DoCmd.OpenForm

and make it read:

DoCmd.OpenForm "form 'b' name", acNormal, , , acFormAdd

11-05-2007, 10:57 AM	#1 (permalink)
95five-0 Registered User Join Date: Dec 2004 Location: Corinth, TX Posts: 1,339 OS: 2000/XP/2003/Vista/2008	Access form question I have no idea why I con't figure this out but it is drving me crazy. I have created a table that has two fields. One that is the ID that numbers the entries and another for text. I am trying to create a form that will allow me to open it enter the text for that field and have it added to the bottom of the table. But for some reason everytime I reopen the form it jus starts over writting everything that was added before. Does anyone know a way to tell it to create a new row everytime? Thanks. __________________ "If it's really a supercomputer, how come the bullets don't bounce off when I shoot it ?" <<PC Pitstop>><< AVG Free>><<Spybot>><<Everest 2.0>><<Trend Micro House Call>><<HijackThis How-to>>

11-08-2007, 03:24 AM	#2 (permalink)
Chevy Retired Join Date: Jul 2003 Location: Notlob Posts: 5,452 OS: Vista Ultimate My System	Re: Access form question The form is opening at the beginning. If you can view the code for the form, look for: DoCmd.OpenForm and make it read: DoCmd.OpenForm "form 'b' name", acNormal, , , acFormAdd