“#Deleted”... Access 2007 / SQL

[Petros]

Hi all,
I am using a popup form for entering new records. On the forms “on Load “ event I use the following code, DoCmd.GoToRecord , , acNewRec..but once the forms is open all controls are populated with “#Deleted”.
Front end Access 2007, backend SQL 2008.
Do i really need to create a command button for inserting new records (the above described issue does not occur when i use the command button), i was hoping to avoid that.
Thanks!

 

[the_net_2.0]

the 'deleted' issue has multiple source reasons. i think the most common might be when the data from the source is changed by another location or another user. the form is dynamic and realtime in that sense of the word. I believe that as soon as data in the source is change (in this case, deleted), the form you're viewing will automatically requery itself to reflect the current state of the table's data.

 

[sullyscsu]

I would either a) put the popup form in Data Entry mode or b) create a Temp table and bind the popup form to that then put the form in Data Entry mode. If you go the Temp table route, make sure there is a way to append the record to your main table and delete the temporary record .

Either way you decide, Data Entry mode alway allows users to always insert a new record.

 

[Petros]

Sorry for my late reply, i thank you both for most valuable suggestions.

I choose the method of referring to the open form in the popup form on current event (this since the backend is in SQL and seems tthat on the load event is premature)..

Once again thanks you for you valuble time!