Add record in subform

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

kRiX - 03 May 2007 09:21 GMT

I got three forms for different modes: namely view/edit mode, delete mode and
add mode.

But there's something wrong with my add mode form. My main form appears but
my subform are nowhere to be found? Is there something wrong?

Reply to this Message

Allen Browne - 03 May 2007 12:58 GMT

For an explanation of why the the subform disappears, see:
Why does my form go completely blank?
at:
http://allenbrowne.com/casu-20.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I got three forms for different modes: namely view/edit mode, delete mode
>and
[quoted text clipped - 3 lines]
> but
> my subform are nowhere to be found? Is there something wrong?

Reply to this Message

kRiX - 07 May 2007 09:31 GMT

Thanks Allen, then how I go about solving this issue? Can I set focus to my
subform and set AllowAdditions to be true? Or what?

> For an explanation of why the the subform disappears, see:
> Why does my form go completely blank?
[quoted text clipped - 8 lines]
> > but
> > my subform are nowhere to be found? Is there something wrong?

Reply to this Message

kRiX - 07 May 2007 10:04 GMT

Hmmm, I tried setting them to what you wrote but still get a blank form.
Maybe you can have a look at my file? Can i send it to your email?

> Thanks Allen, then how I go about solving this issue? Can I set focus to my
> subform and set AllowAdditions to be true? Or what?
[quoted text clipped - 11 lines]
> > > but
> > > my subform are nowhere to be found? Is there something wrong?

Reply to this Message

Allen Browne - 07 May 2007 14:45 GMT

Please don't send the file. We do need to get some work done, beyond this
volunteer stuff.

The article explains how to address the issue. Or perhaps you are using a
read-only query as the source for your form. Easy enough to open the query
directly and test it. If it is non-updatable and you don't know why, see:
http://allenbrowne.com/ser-61.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hmmm, I tried setting them to what you wrote but still get a blank form.
> Maybe you can have a look at my file? Can i send it to your email?
[quoted text clipped - 17 lines]
>> > > but
>> > > my subform are nowhere to be found? Is there something wrong?

Reply to this Message