473,378 Members | 1,364 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,378 software developers and data experts.

Making Subforms appear with the click of an option button

Hi,

As the title says im trying to make a subform appear depending on which option button is selected, is this possible and if so would it mostly involve coding? Im guessing i would have to do an OnClick Event or would it be After Update?

Cheers,

Bobby Banks!

(Please PEB My Saviour help me ;D)
Nov 17 '06 #1
4 2214
nico5038
3,080 Expert 2GB
I guess you have a problem with the space on your form.
Personally when I need multiple subforms I just add a Tab control and place on each tab a subform.
For a user this is a known way to navigate to related data and it would even allow you to show only tabs that are relevant to the type of data displayed on the mainform.
The tabs act then as your subform selectionbutton and no code is needed when you don't have to suppress tab's.

Idea ?

Nic;o)
Nov 17 '06 #2
MMcCarthy
14,534 Expert Mod 8TB
Hi,

As the title says im trying to make a subform appear depending on which option button is selected, is this possible and if so would it mostly involve coding? Im guessing i would have to do an OnClick Event or would it be After Update?

Cheers,

Bobby Banks!

(Please PEB My Saviour help me ;D)
Nicos idea is the way I would do it as well.

However, if you really want to follow your original idea all you have to do is make the subforms invisible one on top of the other and then toggle them visible/invisible using command buttons.
Nov 17 '06 #3
wow good stuff!

Thanks for the ideas! ill try them both and see which one suits my needs best!

Cheers !

Bobby.
Nov 17 '06 #4
MMcCarthy
14,534 Expert Mod 8TB
wow good stuff!

Thanks for the ideas! ill try them both and see which one suits my needs best!

Cheers !

Bobby.
No problem.

Anytime.
Nov 17 '06 #5

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

Similar topics

1
by: ehm | last post by:
I apologize in advance for the cross-post (from microsoft.public.inetexplorer.scripting), but that board seems dead. I have what I think is a fairly simple problem, but I cannot figure this out....
0
by: CSDunn | last post by:
Hello, I have an Access 2000 ADP main form called frmAD_OpeningForm that needs to support several possible sub forms. The subform that should appear would be based on the combined bound values...
3
by: Diana Gard | last post by:
Perhaps this is a design flaw, please let me know. I'm using Access 2000. I have a form with a tab control and 5 subforms within those tabs. The forms match with the tables: Client main,...
7
by: lauren quantrell | last post by:
A while back I got a requirement for the client to be able to adjust the relative heights of two subforms by click-dragging the mouse and I came up with a kludge solution using a border control...
4
by: microb0x | last post by:
I have an application with a master form with a tab control containing nine tabs, each tab contains a subform. I have command buttons on my main form including: Save , Cancel , Close. My...
4
by: Harlequin | last post by:
I have a question concerning the need to trigger events within a "child" subform which is itself enbedded within a master "parent" form and which is accessible via a tab in the parent form. Becuase...
11
by: TechnoAtif | last post by:
Here is the other one..This requires a textbox to open while clicking of a radiobutton in one part and in the other part on the click of a list/menu. I want that..as I click the second...
3
by: Zippy | last post by:
I have recently moved from A97 to A2003. I find it inconvenient that I can no longer double-click on the subform to open it in full view. I had a hunt around the newgroups and couldn't find...
5
sickenhoofer
by: sickenhoofer | last post by:
I have a form w several subforms. The ultimate goal would be to click on a location, and have the data in the other subforms change to the data specific to that location. For this form, there are...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

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.