Opening a sub-form from a command button

I have a sub-form with in a main form. The sub-form opens with the form. I 
want tthe sub-form to open separtely, such as with a command botton.

And if this cannot happen, then I want to delete the sub-form and have the 
form (that was the sub-form) to open with a command button, but for it to be 
sized to fit with in the area that the sub-form had opened in. 

I acually have several sub-forms that open with the main form, each with in 
their own page. The the database on the server and with multible users, the 
database slows way down. 

I want to open each sub-form as needed (instead of as the user moves to 
another record). Each form would also need to close as the user moves to an 
other form (sub-form), or when moving to the next record. 
-- 
Preston
0
Utf
5/27/2010 9:01:44 PM
access.forms 6864 articles. 2 followers. Follow

1 Replies
1214 Views

Similar Articles

[PageSpeed] 43

why dont you use normal forms and open then forms from command buttons
having the properity on the form modal set to yes.  this means they
will have to close down that form before they can do anything else.

i supose if you want to do this you could try this

you need to have a blank subform to replace the other subforms when
they open

and on your subform controls use the blank subform as the sourceobject

YOU CANNOT NOT SET THE SOURCEOBJECT TO NOTHING OR "" WHICH IS WHY YOU
NEED THE BLANK SUBFORM

Private Sub showsubform1button_Click()
    frmsubform2.SourceObject = "frmblanksubform"
    frmsubform.SourceObject = "frmsubform"
    [Forms]![frmmainform]![frmsubform].SetFocus
End Sub

Private Sub showsubform2button_Click()
    frmsubform.SourceObject = "frmblanksubform"
    frmsubform2.SourceObject = "frmsubform2"
    [Forms]![frmmainform]![frmsubform].SetFocus
End Sub

i cannot get a lostfocus thing to work but you coudl try to target the
change of record as then set all the subforms to the blank subform.

Hope this helps

Regards
Kelvan
0
Lord
5/28/2010 2:14:18 AM
Reply:

Similar Artilces:

Files Corrupted - Won't Open
I am starting to see more and more publisher files corrupted I think? I cannot open the stupid things.. :-p I tried please... it still refused! The nerv! Each time I open the files Publisher Crashes without evening loading the document. It's a vicious loop! I've tried opening the document in safe mode, still fails. I tried not showing the pictures, at first it works. But after saving, closing, and trying to open again publisher crashes. I even tried with one file deleting all image objects that I could discern. Still after saving and closing it began crashing publisher again. ...

Forms #5
I know how to create a form. Is there a way to have the form automatically come up when I create a new message/calendar/task? Any help is appreciated. Thank you! See http://www.outlookcode.com/d/newdefaultform.htm FYI, there is a newsgroup specifically for Outlook forms issues "down the hall" at microsoft.public.outlook.program_forms or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_forms -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming - Jumpstart for Administrators, Power ...

Problems opening Workbook
Hi All, My Problem is that when I try to open my Accounts workbook I have this notice appear:- "! Too Many Different Cell Formats". Then the workbook will not open. If I could open the workbook then I can rectify the problen of too many cell formats. So does anyone know how to force the workbook to open? Thanks Becky Check your other post. Rebecca wrote: > > Hi All, > My Problem is that when I try to open my Accounts workbook I have this > notice appear:- "! Too Many Different Cell Formats". Then the workbook will > not open. > If ...

I can not copy text into a brochure without another textbox opening
Hi all, Every time I try to copy and past into a textbox already created by a publisher template, another textbox is created by defalut to add the text into it. I want to just add the text into the textbox already within the template like you could with Publisher 2000. Thanks, Kelsey Is your cursor inside the textbox when you paste? If you just paste Publisher will create a new text box. If this isn't the answer create a new textbox, paste and delete the original text box. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com &q...

Where do I find the commands for a macro
I recorded a macro to input a number, move right 3 spaces, enter a number, ect ....... when I recorded it I intended to go back and replace the numbers I put in to record with whatever I need like a question mark. Here is the macro as it is now: Sub Macro1() ' ' Macro1 Macro ' ' Keyboard Shortcut: Ctrl+a ' ActiveCell.FormulaR1C1 = "123" Range("E64").Select ActiveCell.FormulaR1C1 = "123" Range("H64").Select ActiveCell.FormulaR1C1 = "123" Range("K64").Select ActiveCell.FormulaR1C1 = &q...

Using Extender to open an existing GP window when in another GP wi
We use GP 10.0 and also own Extender. When I attended an Extender session at Convergence last year, I seem to remember we were told it is possible to use Extender to add a link to a GP window to open another GP window. Does anyone know how to do this? For example, when in a customer card, I would like to be able to click on the "Additonal" tab up the top and select the window: Field Service - Inquiry - Contract Administration - Contracts by Customer Inquiry. Thanks for your help. You could only open GP windows using the Extender. I do not think there is a way to open up other...

Can not open my database
Hello, I have this error message when I opened my database. I have seen that in the help about and I see that that document: filename.mdb was disabled. The document filename.mdb caused a serious error the last time it was opened. Would you like to continue opening it?" I tried to enable it but the same error message still occured. Let me tell you the storry, before that I have the file name: thumb.ldb in my database folder, and I tried to delete it to recylcebin, it says that it is a systemfile. but since I do not feel it is my file, I go on to delete it. Anyone kno...

XLS Files Will Not Open
We have a PC that will open Excel files, but only if you open Excel and then open the file from Excel. If I go straight to the file and try to open it, it gives an error saying "cannot find file...make sure the file and path are correct...". If I go into Excel and go to File>Open and open the file from there, the file opens fine. I've check the Excel assocations and such and everything looks fine. I've seen this once before and there was a registry setting that fixed it, but I don't remember what it was. Has anyone seen this before? Thanks, Phil Phil Fi...

GP printing PM checks to Acuprint using ACL command line
Looking for experience of printing Great Plains PM checks to Acuprint. Have client that is trying to do this by adding ACL command line in check format report writer to tell Acuprint which template to use. Anyone successful in doing this? Thanks. ...

Send/Receive button has failed
Neither the send/receive button on the standard toolbar nor the F5 button are working. However, I can get email by going to tools-->send/received-->2 All Accounts. Can anyone tell me how to get the these buttons to work again? Tod ...

Upload from a Form in Excel
--____XLRKAGQPPHGFAFLCQLOX____ Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 Content-Disposition: inline; modification-date="Fri, 24 Apr 2008 04:47:16 -0500" SSBoYXZlIGEgZm9ybSBpbiBleGNlbCB3aGljaCBjb250YWlucyA4IHZhbHVlcywgYW5kIEkgd291 bGQgbGlrZSBmb3IgdGhvc2UgdmFsdWVzIHRvIGJlIHRyYW5zZmVycmVkIHRvIGEgZGlmZmVyZW50 IHNoZWV0IG9uY2UgYSBzcGVjaWZpYyBidXR0b24gaXMgcHVzaGVkIGZvciB1cGxvYWRpbmcgcHVy cG9zZXMuIElzIHRoaXMgZXZlbiBwb3NzaWJsZT8= --____XLRKAGQPPHGFAFLCQLOX____ Content-Type: multipart/related; boundary="____XXAXWWJCNYSCZDUXOBNI____" --____XXAXWWJ...

Different Button Position When On Design Screen and Application Ru
I use MFC Visual C++ 4.2. I am customizing an application. The existing application has already got buttons, CListView, etc. I just add a button next to other button. There are 4 buttons in a row. I've placed it in a good order following the existing buttons, but when I ran the app, the position changed. The button I'VE JUST CREATED moved from its position. Why it can be happen? How to solve this? Thank you. Will your application compile and build with the latest free version of Visual Studio? You might try that, since your version of vc++ is dated. "Landon" ...

Form Viewing Problem
Hi, I've created a new Form for logging in phone calls. I've created the worksheets and relationships. My problem is I was able to view (and use) my Form yesterday, but then added a new field. Now, under the Form tab, I can only view the Design View, not the Form or Layout View (it only shows the header and there is a small black dash in the top right section of where the body should be). The same is true for the Phone Log Worksheet (all my previously entered data is there). If I open the Copy of the Form, I can see all the Views. I tried to remove the new field hoping th...

Form for Engineering Standards
Is there a form already created that could be usable for Engineering Standards? It would need a table at the top with text boxes and borders around the page. -- Cathy You probably will have to create this yourself. There is a page here that might help: http://www.library.drexel.edu/resources/guides/engstandards.html -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "Cathy" <Cathy@discussions.microsoft.com> wrote in message news:801ABEF0-C189-4C5A-8C1F-FF78E7C33FE5@microsoft.com... > Is there a form already created...

Form Caption Logo, How?
How do I put a logo in the User Form Caption Line. Thanks http://www.dicks-blog.com/archives/2005/01/11/updated-formfun-example "WTG" <wtg_designs@hotmail.com> schreef in bericht news:oaj321du2qfe7apcmkc9tpi09g9p9gpehn@4ax.com... > How do I put a logo in the User Form Caption Line. > > Thanks ...

Applying Filter to Form in a Looping Macro Causes Catastrophic Err
I have a form that contains order details and I run through a loop that applies a filter to the form (only view one order at a time), and then removes the filter, applies a different filter (next order) and then removes it etc. After about 300 times, I get a message stating "not enough memory..." This is fairly consistent and have narrowed it down to being a MS Access issue (as opposed to a hardware issue). I have reduced the number of times the looping macro runs to 100, and finishes successfully (without the memory error), but renders the keyboard useless for changing an...

SSRS Advance Services and passing parameters via <form>
I'm new to SSRS. I'm using SQL Server Express with Advanced Services, and I have a report working. The report has a Parameter defined as "ReportDate". In the report design, I have a subheading expression that goes like this: ="For " & Parameters!ReportDate.Value I'm trying to invoke the report from an ASP.net MVC app like this: <form id="frmReader" action=" http://localhost:8080/Reports_SQLEXPRESS/Pages/Report.aspx?ItemPath=%2fReports%2fDonorAccountHistory " method="post" target="_blank&qu...

Address book very slow to open
I have a few users on my network running Outlook XP sp2 against an Exchange 5.5 server who regulary complain that opening their address book, by clicking the TO: button can take up to 10 minutes to open. has anyone else had similar experience and if so, can it be resolved? Thanks in advance ...

access repot/form
I need to make a form AND a report showing price times quantity where the price is determined by the date of the entry. Prices change often and I need to select the correct price for the entry as well as print past entries. "SolarComputing" <SolarComputing@discussions.microsoft.com> wrote in message news:040E8560-8E59-44B3-A5B2-975E083D5F79@microsoft.com... >I need to make a form AND a report showing price times quantity where the > price is determined by the date of the entry. Prices change often and I > need > to select the correct price for the ...

Outlook Faults out when other when mail is opened and other users Calendars are selected:
Hello all (especially MS) Got one that has me stumped here and I'd love to see some suggestions or possibly a confirmation that this is a bug of some kind: Got an end-user who manages the calendars of multiple executives. As such she has delegated access to all of their calendars. The Back-Office system is as follows: Active/Active/Passive Exchange 2003 SP2 Mail Server running on Windows 2003 SP1, along with 3 Front-End Servers (two SMTP and One OWA/OMA/ActiveSync Host). Client - Windows XP SP2, Outlook 2003 SP2, all updates pushed to system via WSUS. Basically Outlook Blows w...

Printing/Forms
Hi I've been asked to present a suggestion for an issue we are having here. There is a spreadsheet- 29 columns, with 188 individual rows. I have to suggest a method for data entry- easy enough, I'll just show them how to use the form function. But more importantly, the data now is presented horizontally. ie if I were to print it, the data for each row would print across the paper. is there any way to keep the column headings where they are, but have the record print the opposite way. (ie in excel there would be column headings, but on paper, it would print verically and th...

Retrieving informations about opened web pages by Internet Explorer
Is there any way to retrieve how many web pages are opened by Internet Explorer, and what URLs are opened by it, from another process? I searched for IHTMLDocument5 and so on, however, I could't find any hint. Please reply. Thanks in advance. Regards, Hyun-jik Bae ...

command button to open 1 of 2 forms
Hi All, I have 3 forms "DailyRoute", "ServiceCall" and "Installation". "ServiceCall" and "Installation" have control source as "TblCustomers" when the customer details are entered a checkbox is check to identify a Service Call, the issue is that different information is required for each job type ("ServiceCall" or "Installation") therefore I require 2 forms for closing the days work. Is it possible to click the "update" command button in "DailyRoute" and display either "Ser...

Restore toolbars in open email
I have lost the toolbars across the top of an open email and would like to restore them, but can't seem to figure it out. View, Toolbars, Standard ? "Confused user" wrote: > I have lost the toolbars across the top of an open email and would like to > restore them, but can't seem to figure it out. Right-click in the area Confused user wrote: > I have lost the toolbars across the top of an open email and would like to > restore them, but can't seem to figure it out. ...

Links dont open
Why is it that n some emails where there are links outlook opens the explorer with strange URL like this outbind://16-0000000026322AE5531BF6438B074869664FD701440D2300/http/www.something.com ...