|
| 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
April 17th, 2008, 07:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Form will not open to 'new record'.
I have one form in a database that is giving me fits. It will not open to a
'new' record for entry of new data. I set the data dentry property to 'yes' and it doesn't work. I created a macro to go to a new record and placed it in the 'on click' event on the form and that does not work. The form always opens to the first record in the underlying table. The form is not directly tied to the table but gets its data from a query based on the table. Any suggestions? -- DMainland 
|
|
#2
April 17th, 2008, 07:52 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Form will not open to 'new record'.
My guess is that your query is not updateable. You can't add new records to
it, nor can you edit or delete existing records. Chris Microsoft MVP DMainland wrote: I have one form in a database that is giving me fits. It will not open to a 'new' record for entry of new data. I set the data dentry property to 'yes' and it doesn't work. I created a macro to go to a new record and placed it in the 'on click' event on the form and that does not work. The form always opens to the first record in the underlying table. The form is not directly tied to the table but gets its data from a query based on the table. Any suggestions? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1
|
|
#3
April 18th, 2008, 02:01 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Form will not open to 'new record'.
I have a similar problem, and I suspected something like that might be the
issue, but how do you make the query updateable? I have a query that simply combines two tables into one, and I have a form based on that query, which I want to use to add records to both tables simultaneously. For me, though, it does add records, but the problem is, if I close the form and reopen it, despite the fact that the query shows records, the form shows only a single, new (blank) record. Any suggestions? Thanks, Ray "Chris O'C via AccessMonster.com" wrote: My guess is that your query is not updateable. You can't add new records to it, nor can you edit or delete existing records. Chris Microsoft MVP DMainland wrote: I have one form in a database that is giving me fits. It will not open to a 'new' record for entry of new data. I set the data dentry property to 'yes' and it doesn't work. I created a macro to go to a new record and placed it in the 'on click' event on the form and that does not work. The form always opens to the first record in the underlying table. The form is not directly tied to the table but gets its data from a query based on the table. Any suggestions? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1
|
|
#4
April 18th, 2008, 02:25 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Form will not open to 'new record'.
Change the form's data entry property to No to see all the query's records.
Chris Microsoft MVP =Ray= wrote: it does add records, but the problem is, if I close the form and reopen it, despite the fact that the query shows records, the form shows only a single, new (blank) record. Any suggestions? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200804/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
