473,811 Members | 3,627 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Open a subform in new a window from a command button

5 New Member
Hi all

I have a form with a few subforms. I want to set the subforms to 'not visible' and open each in an individual popup window from command buttons. If anyone knows a better way of opening multiple subforms from buttons rather than having them all 'open' at once on a large form then please let me know! I can't work it out!

Thanks
Mar 25 '08 #1
3 4477
lee123
556 Contributor
hi loisjones,

you already have a post for this subject i suggest you don't post the same question anymore you have to read the posting rules again. for posting twice this is prohibited

lee123
Mar 26 '08 #2
louisjones
5 New Member
Sorry guys, didn't realise
Mar 26 '08 #3
mshmyob
904 Recognized Expert Contributor
Why don't you use TABS. You could have buttons if you want on the 1st tab that activates the display of the tab you want and then when you lose focus hide it.

Or just leave them all displayed like normal and the user selects the tab they want and gets the appropriate subform based on the tab they chose.

cheers,

Hi all

I have a form with a few subforms. I want to set the subforms to 'not visible' and open each in an individual popup window from command buttons. If anyone knows a better way of opening multiple subforms from buttons rather than having them all 'open' at once on a large form then please let me know! I can't work it out!

Thanks
Mar 26 '08 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
12610
by: deko | last post by:
I have two subforms within a particular form. The one on top is a datasheet of transactions; the one on the bottom is a summary of totals. I would like to have the datasheet fill the entire parent form until a command button is clicked, then have the datasheet form shrunk to half it's original height and have the totals summary form appear below it. The totals summary sheet, then, would not be visible until the command button is clicked,...
1
314
by: Richard | last post by:
Thats a mouthfull of a title what I'm after should be really simple. I have a form with a subform which itself has a subform the final subform contains an individuals record. The individuals details will not fit on the form so I would like to put a command button on it to Open the individuals details up - I would like this Other form to be Opened at the same record as the subform - I use the form as a menu and the first subform is a...
6
3951
by: Sally | last post by:
I need to be able to click in a subform and run code but at the same time I need to be able to scroll the records without running the code. I tried coding the Enter event of the subform control but when I try to scroll the records the code runs. The subform is continuous; all the controls are on one line and the detail section is not exsposed above or below the controls. I tried coding the detail Click event but nothing happened. I tried...
1
5776
by: dmkeith2 | last post by:
I have a command button on my subform that I would like to run when the subform loads. Is there a way to run the command button that is in the subform automatically. Thanks
14
11474
by: Kurt | last post by:
I have an unbound main form with an unbound subform. frmProjects fsubProjectList Using combo boxes, the user can select several search criteria on frmProjects and then click a command button. The command button passes the criteria as a string to a query. A subform, which is based on this query, shows the results of the search.
4
3185
by: piscogirl | last post by:
Hi all, Here's my case: I have a form: Event Form and a subform: AttendanceSubForm The user selects a name (from a Person Table) on the subform to register for the event. If the name is not there, they are to click a
1
3243
by: google | last post by:
I have a form with several subforms. Users enter the data, then on the parent there is a command button that runs code to generate a .pdf document from a report based on the data they are working with. If a user enters data in a subform, then directly clicks the command button on the parent form, the data in the subform is not included in their document. I THOUGHT that as soon as focus left the subform, any pending changes to the data...
14
25072
by: keri | last post by:
Hi, Simple version of the question..... How do I use the where clause of the open form command to show an account with a matching ID to be displayed when the form is opened? Eg. I select a record on a continuous form and click and edit button. The button runs the open form code. I want the APPID of the current record on the continous form to match the APPID of the record viewed
2
6837
by: jmartmem | last post by:
I have an Access 2002 main form ("Project Update Form") with a subform ("sfEZMilestone"). What I want is to somehow change the subform to a command button so when a user clicks the command button, it will open the subform in a new window (like a pop up window). There, the user can update and edit the fields as necessary then close the window and return to the main form. The Link Child Field is ID and the Link Master Field is ID. ...
0
9730
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10651
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
1
10403
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10136
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
7671
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6893
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
1
4341
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3868
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.