subform pop up for better viewing

[Dustin]

Hello,
I have a main form containing the customers info that has a tab control
beneath, in each tab there is a subform bound to a query that shows more of
details of the customer. I want to click a button and basically maximize or
open the subform to full screen for better viewing of that customers details.
Also have a button that views the customer details in a report. How do I keep
the full screen subform and the report linked to who is selected on the main
form.

Thanks,
Dustin

 

[Jochen]

Do you want every seperate subform to be able to "maximize" or do you want
the tabs to still be available in the maximized subform?

Both ways require you to design a new form (you can make it any size you
want and design it as you want it). In theory you could also use the existing
subform but I think a new form would be the way to go. Put all the info you
want to appear when you maximize the form on this new one.

Now create the button in the subform you want to maximize and create a macro
for it's on click event which holds

Runcommand
Command: SelectRecord
OpenForm
FormName: [YourNewForm]
View: Form
WhereCondition: ="[CustomerID]=" & [CustomerID] (assuming customerID is
the link between the forms, else change it to whatever you use
Window Mode: Normal

That should work I guess

 

[Dustin]

I've gotten the form to pop up but it cant find the customerID from the main
form.
It pops up a Enter Parameter Value box asking for the Customer ID? Then I
enter the ID number I am looking for and it brings me a new record and I
click the undo filter button and there are all of the records in that form.

This is what I have written.

="[CustomerID]=" & [CustomerID]

I tried this as well.
="[CustomerID]=" & [TODOCustID]
These are links between forms and it gave me this Statement.

The object doesn't contain the Automation object 'TODOCustID'

Any advice would be apprecieated

Thanks Dustin

Do you want every seperate subform to be able to "maximize" or do you want
the tabs to still be available in the maximized subform?

Both ways require you to design a new form (you can make it any size you
want and design it as you want it). In theory you could also use the existing
subform but I think a new form would be the way to go. Put all the info you
want to appear when you maximize the form on this new one.

Now create the button in the subform you want to maximize and create a macro
for it's on click event which holds

Runcommand
Command: SelectRecord
OpenForm
FormName: [YourNewForm]
View: Form
WhereCondition: ="[CustomerID]=" & [CustomerID] (assuming customerID is
the link between the forms, else change it to whatever you use
Window Mode: Normal

That should work I guess

Hello,
I have a main form containing the customers info that has a tab control
beneath, in each tab there is a subform bound to a query that shows more of
details of the customer. I want to click a button and basically maximize or
open the subform to full screen for better viewing of that customers details.
Also have a button that views the customer details in a report. How do I keep
the full screen subform and the report linked to who is selected on the main
form.

Thanks,
Dustin

 

[Jochen]

Where did you place the button? On the main form, tab control or the subform?
Make sure the field you link is available on both the form where the button
is as well as the new form that pops up (they can be visible or not, doesn't
matter)

Does the subform show only one record or is it datasheet view with several
records?

if you have placed the button in the subform and the CustomerID is on the
main form change the code to:

="[your popup customerID]=" & [Forms]![your main form name]![your main form
customerID]

I've gotten the form to pop up but it cant find the customerID from the main
form.
It pops up a Enter Parameter Value box asking for the Customer ID? Then I
enter the ID number I am looking for and it brings me a new record and I
click the undo filter button and there are all of the records in that form.

This is what I have written.

="[CustomerID]=" & [CustomerID]

I tried this as well.
="[CustomerID]=" & [TODOCustID]
These are links between forms and it gave me this Statement.

The object doesn't contain the Automation object 'TODOCustID'

Any advice would be apprecieated

Thanks Dustin

Do you want every seperate subform to be able to "maximize" or do you want
the tabs to still be available in the maximized subform?

Both ways require you to design a new form (you can make it any size you
want and design it as you want it). In theory you could also use the existing
subform but I think a new form would be the way to go. Put all the info you
want to appear when you maximize the form on this new one.

Now create the button in the subform you want to maximize and create a macro
for it's on click event which holds

Runcommand
Command: SelectRecord
OpenForm
FormName: [YourNewForm]
View: Form
WhereCondition: ="[CustomerID]=" & [CustomerID] (assuming customerID is
the link between the forms, else change it to whatever you use
Window Mode: Normal

That should work I guess

Hello,
I have a main form containing the customers info that has a tab control
beneath, in each tab there is a subform bound to a query that shows more of
details of the customer. I want to click a button and basically maximize or
open the subform to full screen for better viewing of that customers details.
Also have a button that views the customer details in a report. How do I keep
the full screen subform and the report linked to who is selected on the main
form.

Thanks,
Dustin