Enter data on SubForm

[alex]

Hello group,

I've been reading several posts about subforms. Many of them say to
base a subform on a query and not directly to the table.

What if the subform is used for data entry? I'm assuming the only
option is to then base the subform on the table sans query.

alex

 

[Jeff Boyce]

Why assume that? Some queries are not updatable, but some are. Is there
something special about your subform?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[alex]

Why assume that?  Some queries are not updatable, but some are.  Is there
something special about your subform?

Regards

Jeff Boyce
Microsoft Office/Access MVP









- Show quoted text -

Thanks Jeff,

There's nothing special about my subform. Would the query have to be
an action query?

 

[Douglas J. Steele]

No , you cannot use Action queries as the RecordSource for forms.

Check what Allen Browne has at http://www.allenbrowne.com/ser-61.html for
some common reasons why queries aren't updatable.

 

[alex]

No , you cannot use Action queries as the RecordSource for forms.

Check what Allen Browne has athttp://www.allenbrowne.com/ser-61.htmlfor
some common reasons why queries aren't updatable.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)






- Show quoted text -

thanks Doug.