473,320 Members | 1,817 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,320 software developers and data experts.

Recordset

Hi-

I have a form that contains a subform.

I found out that subform is always executed first, before the main form.
(Prove: I had MsgBox in Form_Current for both forms. MsgBox
from the subform showed up first before the main form)

Question: Is there anyway I can call the main form _before_ the subform?
There are a few fields in the subform that are dependent on the Main Form.

My problem will be easily solved when the Main form is called first _Before_
the subform.

Please advise,
Jenny
Jul 17 '05 #1
2 2923
On Wed, 30 Jul 2003 15:13:50 -0400, in comp.lang.visual.basic "Jenny
Kurniawan" <jk********@maxxiscanada.com> wrote:
| Hi-
|
| I have a form that contains a subform.
|
| I found out that subform is always executed first, before the main form.
| (Prove: I had MsgBox in Form_Current for both forms. MsgBox
| from the subform showed up first before the main form)
|
| Question: Is there anyway I can call the main form _before_ the subform?
| There are a few fields in the subform that are dependent on the Main Form.
|
| My problem will be easily solved when the Main form is called first _Before_
| the subform.


Set your subform to invisible upon opening the entire form.
Once all the criteria is met in the main form then reset the subform
to visible.

It doesn't solve you problem - just hides it :-)
---------------------------------------------------------------
jn****@yourpantsbigpond.net.au : Remove your pants to reply
---------------------------------------------------------------
Jul 17 '05 #2

"Jenny Kurniawan" <jk********@maxxiscanada.com> wrote in message
news:yN***************@news20.bellglobal.com...
Hi-

I have a form that contains a subform.

I found out that subform is always executed first, before the main form.
(Prove: I had MsgBox in Form_Current for both forms. MsgBox
from the subform showed up first before the main form)

Question: Is there anyway I can call the main form _before_ the subform?
There are a few fields in the subform that are dependent on the Main Form.

My problem will be easily solved when the Main form is called first _Before_ the subform.

Please advise,
Jenny

Are you accessing any of the controls or properties on the subform. If you
are, that will Load the form. Can you give any other details?

Paul_W

Jul 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: gary artim | last post by:
Hi All, I have a problem using DBIx::RecordSet. I get correct results but continue to get these messages on stderr. I looked at Compat.pm and it seems to be pointing out a problem with my call...
4
by: Tom | last post by:
I want to open a recordset object on an .asp page. When I open the recordset I would like to use a stored procedure that expects a parameter to be passed for the stored procedure. I will then use...
19
by: Adam Short | last post by:
I am trying to write a routine that will connect a .NET server with a classic ASP server. I know the following code doesn't work! The data is being returned as a dataset, however ASP does not...
0
by: CFW | last post by:
I thought this was going to be easy but I'm missing something . . . I need to open an ADODB recordset using the recordset source for a list box on my for. When my form opens, the list box ADODB...
6
by: lenny | last post by:
Hi, I've been trying to use a Sub or Function in VBA to connect to a database, make a query and return the recordset that results from the query. The connection to the database and the query...
36
by: kjvt | last post by:
Based on a prior posting, I've written a function to convert a recordset to a dataview. The first call to the function for a given recordset works perfectly, but the second call always returns a...
0
ADezii
by: ADezii | last post by:
Most Access Users realize that Recordsets, being virtual representations of a Query, Table, or SQL Statement, exist only in our PC's memory. They, and the data they contain, literally exist at one...
0
ADezii
by: ADezii | last post by:
When you create an ADO Recordset, you should have some idea as to what functionality the Recordset does/does not provide. Some critical questions may, and should, be: Can I add New Records to the...
6
by: Oko | last post by:
I'm currently developing an MS Access Data Project (.adp) in MS Access 2002. One of the reports within the DB uses data that is Dynamic and cannot be stored on the SQL Server. To resolve this, I...
2
by: wallconor | last post by:
Hi, I am having a problem using Dreamweaver CS3 standard recordset paging behavior. It doesn’t seem to work when I pass parameter values from a FORM on my search page, to the recordset on my...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.