In Access Project with SQL Server
A Continus form is bounded to a tabel with Identity field
the form has child subform liked through this identity field
If i add new record,
i can't add to the child field untill i move from the main record
since the identity field will not take a value until i move from field
is there any command to let the identity field takes its value
while the user still editing the same record.
from the Originator,
I already try DoCmd.Save DoCmd.RunCommand acCmdSave but not works.
I also notice that if the user click the record selector then the icon will be changed to show that the record is saved and the identity will apear , but it is not nice to tell the user to click the record selector