Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 12-05-2009
Member
 
Join Date: Jan 2009
Posts: 74
Cannot add new record to sub-form

I have created a form in which there are more 3 sub-form edit, add, delete form, But when i try to goto Add form and add some record over here i am able to add records but as soon i try to go in Edit Form i am not able to see any updates having over here.I don't know what's wrong can anyone tell me what i need to do in this case.
Reply With Quote
  #2  
Old 12-05-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: Cannot add new record to sub-form

Click on EDIT button's and goto Click event procedure over here goto OpenForm line and make sure the Datamode argument is acFormEdit or not specified if the form's properties have bot AllowEdits and AllowAdditions set to Yes.
Reply With Quote
  #3  
Old 12-05-2009
Member
 
Join Date: Oct 2005
Posts: 2,389
Re: Cannot add new record to sub-form

There would be some other issue too while updating any query with multitable.Multitable query can only be updateable if the joins are from fields with a unique key also try to right-click on the subform and select Form, now click on the data tab now say YES to Allow additions, Allow modifications, Allow deletions.Make sure that each column in the grid has Read-only set to No.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Cannot add new record to sub-form"
Thread Thread Starter Forum Replies Last Post
Google Chrome is opening in basic HTML form instead of the Standard form Beatrix Technology & Internet 5 25-05-2011 10:21 PM
how to get items in a form to auto-resize with the form using visual basic deansmylie93 Software Development 2 02-05-2011 07:06 AM
How to Auto Populate fields from sub form to form? mich43 Windows Software 6 09-11-2010 11:29 PM
Procedure in VB to create form inside another form Jalabala Software Development 3 16-11-2009 02:14 PM
Problem reloading MDI child form in main form. AFFAN Software Development 3 30-01-2009 09:05 PM


All times are GMT +5.5. The time now is 12:50 AM.