PC Review


Reply
Thread Tools Rate Thread

adding record trough subform

 
 
rocco
Guest
Posts: n/a
 
      12th Sep 2003
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
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a new record in Subform--Please Help!!!!!! Richard Microsoft Access Form Coding 2 28th Jan 2009 04:14 AM
adding a new record at subform should update an existing record (not create new record) Mark Kubicki Microsoft Access Form Coding 1 16th Jan 2009 08:34 AM
How does one protect against subform adding record before main form has record? Chips Microsoft Access Forms 3 2nd May 2004 04:19 PM
form / subform - problem adding new record! - can't save main record Bob Microsoft Access Forms 2 7th Oct 2003 06:19 PM
Stop adding record in subform after record count = 1 Charlie Microsoft Access Forms 0 31st Jul 2003 11:42 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:15 AM.