adding record trough subform

R

rocco

Hello,
I have builded a form (named "general") with a tabcontrol
on it (6 pages). Each page has a subform.
The forms underlying the subforms has those properties
setting:
Allowdeletion=yes
Allowaddition=yes
Allowedits=yes
Dataentry=yes
Cycle=currentrecord
This is because I want that the user can go back and for
trough the pages without the records changes.
I have builded a command button posted on the header of
the General form. This command should save the current
record and go for each page to a new blank record.
I can't use the docmc.gotorecord ,., acnewrec because it
ask for a form name and it seems not working with the
subform name (obviously).
I have tried creating a recordset obj and setted it to
forms("general").controls.
(subform.name).form.recordset.clone
Then I tried to use the movenext method and the bookmark
to go to a new record.
It works only if I first of anything else change the
dataentry property from "true" to "false".
There is any other less complicated way to add new record
trough subform maintaining the setting I made?
thanks,
rocco
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top