SubForm

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hi

How can I open subform on the main form to Enter new data?
I have button which On_Click event reveals SubForm (Visible=True) and
SubForm is prepared for entering new records.
Thanks, Chris
 
Hi

How can I open subform on the main form to Enter new data?
I have button which On_Click event reveals SubForm (Visible=True) and
SubForm is prepared for entering new records.
Thanks, Chris
Click to expand...

You don't need to "open" a Subform, and you shouldn't need to do
anything special to make it open for entering new data. What specific
problem are you having?

Possibly the Subform is based on a query which is itself not
updateable. If you open the Subform's Recordsource query as a query
datasheet, do you have a *> new record line visible at the bottom?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Hi John

My Subform is based on Form. My subform is by default not visible (visible
property is set to False). I would like to have two buttons on the main
form; one to activate subform.visible=True and present form for new entry
(something like data.entry=true) and other button which will also activate
subfo visibility to true will present selected records due to selection on
main form.

Is that possible to do in that way?

My intention is to have related data clearly presented on one form with
subform since I haven't suceeded to possition forms in the way that I want
(the only Forms possition tool is Auto_Center which is not satisfying my
idea; I'd like to have something as Top and Left but for Form possitioning)

Thanks
 
Hi John

My Subform is based on Form.
Click to expand...

A subform IS a Form. It can't be "based on" a Form; any Form (whether
used as a subform or not) is "based on" a Table or a Query, called the
form's RecordSource.
My subform is by default not visible (visible
property is set to False). I would like to have two buttons on the main
form; one to activate subform.visible=True and present form for new entry
(something like data.entry=true) and other button which will also activate
subfo visibility to true will present selected records due to selection on
main form.

Is that possible to do in that way?

My intention is to have related data clearly presented on one form with
subform since I haven't suceeded to possition forms in the way that I want
(the only Forms possition tool is Auto_Center which is not satisfying my
idea; I'd like to have something as Top and Left but for Form possitioning)
Click to expand...

Is this actually a Subform, i.e. do you have a Subform Control on your
main form? Or are you opening a *separate, stand-alone form* in VBA
code? If so, it's not a Subform. A Subform Control can be moved around
on your form, just like any other type of control; you can put it on a
page of a Tab Control if you wish to hide it except when it's
selected; you can set its Visible property to True or False. I do NOT
understand what you're trying to do with the Data Entry property;
setting Data Entry to True for a Form conceals all the existing data,
and makes it possible to add new data but not to review existing data,
which doesn't sound like what you intend!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top