Sub form in main frame

  • Thread starter Thread starter F. Angers
  • Start date Start date
F

F. Angers

Hi,

Does someone know if it's possible to have a form in this way.

1. at the top like the lastname and firstname like usual.

2. On the left have a column of action bottom to change the subform at the
center of the mainframe.

So withouth change main form, juste change the subform. is it possible?

thx
 
Hi,

Does someone know if it's possible to have a form in this way.

1. at the top like the lastname and firstname like usual.
Click to expand...

I wouldn't say "like usual"... databases may have many different kinds
of contents; people's names are only one of these!
2. On the left have a column of action bottom to change the subform at the
center of the mainframe.

So withouth change main form, juste change the subform. is it possible?
Click to expand...

Yes; you can change the SourceObject property of the Subform control
to a different form, in the AfterUpdate event of the listbox ("column
of action bottom" in your terms) on the form.

Could you explain what the options are, and why you need to change the
subform?

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

The only reason for change the subform is juste because all my form always
have the same headzone, and the same choice (bottom).,

So if i understand if i choose correctly my actions i'm supose to be easyly
change the data of the subform that it?. i'm surprise, i will take a look.


thanks.
 
thanks a lot,

The only reason for change the subform is juste because all my form always
have the same headzone, and the same choice (bottom).,

So if i understand if i choose correctly my actions i'm supose to be easyly
change the data of the subform that it?. i'm surprise, i will take a look.
Click to expand...

Bear in mind that a Form (or Subform) *IS ONLY A WINDOW*. It does NOT
contain any data. It is neither necessary nor appropriate to have
different forms just to display different sets of data, only for
different *kinds* of data!

If you base your Subform on a Query with variable parameters, the
subform will display whichever records meet those criteria.

I have no idea, however, what you mean by "headzone" or "choice
(bottom)".

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