Object Source / Control Source

S

Shakeel Ahmad

Hello

I have created a database regarding the School System.

I have created three forms (one form and two subforms)

one main form is (Students) where i enter student's name, father's name,
phone, address etc.

now on the main Student form i want to place a subform. But the thing i want
to know is:

I want to make two buttons on my main form (Fees) and (Progress).. because i
have two subforms (sbffees and sbfprogress)

now the record source of subformbox should be controled with these two
buttons. when i click the ( Fee) button the Source Object should be
(sbf-fee)
and when i click the (Progress) button the Source object of the subform
should be (sbfProgress)

How can i do this..... and Advance thanks for the repliers because i am
sure, i will get from here what i need.

--
Best Regards

Shakeel Ahmad

(e-mail address removed)
www.groups.yahoo.com/group/islam-the-final-truth
www.geocities.com/shakeelahmad_79
 
J

John W. Vinson

Hello

I have created a database regarding the School System.

I have created three forms (one form and two subforms)

one main form is (Students) where i enter student's name, father's name,
phone, address etc.

now on the main Student form i want to place a subform. But the thing i want
to know is:

I want to make two buttons on my main form (Fees) and (Progress).. because i
have two subforms (sbffees and sbfprogress)

now the record source of subformbox should be controled with these two
buttons. when i click the ( Fee) button the Source Object should be
(sbf-fee)
and when i click the (Progress) button the Source object of the subform
should be (sbfProgress)

I'd REALLY recommend using two Subforms. You can put them on two pages of a
Tab Control, and use the option in the tab control to use buttons rather than
tabs for the appearance. This will give the user interface view that you want.

Changing the SourceObject property of a subform is clunky and can degrade
performance, and runs into real problems if you have security enabled; every
user will need rights to change the design of the form (which you might not
want them to have lest they make other changes!)

John W. Vinson [MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Object Source / Record Source 9
is it possible? 3
How can I this??? 3
Main Form (Urgent Please) 4
Sharing Database over LAN 4
SynchedCombosV2003 1
IIS (WindowsXP) 4
Managing Stock 3

Top