A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Cannot add records to subform



 
 
Thread Tools Display Modes
  #1  
Old February 10th, 2010, 10:10 PM posted to microsoft.public.access.forms
TC2004
external usenet poster
 
Posts: 38
Default Cannot add records to subform

I have a form with a subform (linked by drag and drop). The main form has a
"Add New Record" button. When I add a new record via the button, I can enter
info in the main form, but not in the subform.

How can I fix this?

Thanks.
  #2  
Old February 10th, 2010, 11:05 PM posted to microsoft.public.access.forms
Pendragon
external usenet poster
 
Posts: 78
Default Cannot add records to subform

Since the button is on the main form, the new record goes to the record
source of the main form. To go to a new record on the subform, either move
the 'Add New Record' button to the subform, or programmatically (VBA) change
the add new record reference to work on the subform instead of the main form.

"tc2004" wrote:

I have a form with a subform (linked by drag and drop). The main form has a
"Add New Record" button. When I add a new record via the button, I can enter
info in the main form, but not in the subform.

How can I fix this?

Thanks.

  #3  
Old February 10th, 2010, 11:39 PM posted to microsoft.public.access.forms
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Cannot add records to subform

On Wed, 10 Feb 2010 14:10:06 -0800, tc2004
wrote:

I have a form with a subform (linked by drag and drop). The main form has a
"Add New Record" button. When I add a new record via the button, I can enter
info in the main form, but not in the subform.

How can I fix this?

Thanks.


By correcting the problem with the subform...

which we cannot see.

I'm guessing that the subform's Recordsource is not updateable, but that's
just a guess.
--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.