473,657 Members | 2,735 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Acc97: Problem with Find Dialog and Sub Form

Hi

I have a main form with some fields directly on the form and others on
a page of a Tab Control. On another page of the Tab Control I have a
sub form. In the On Current event of my main form I have some code
that refers to a field on the sub form. Under normal circumstances
this works fine. If I then select a field directly on the main form
and use the Find Dialog, everything works OK, but if I select a field
on the Tab Control and then use the Find Dialog an error is produced.
Error number 2455 "You entered an expression that has an invalid
reference to the property Form". My code then breaks on the line of
code that refers to the field on my sub form. It's acting as if the
instance of the form class in the sub form control has not yet
initialised. I have tried re-writing the code using the following
types of syntax.

Me.frm_SubFormN ame.Form.Contro lName
Forms!frm_MainF ormName!SubForm Name!ControlNam e
Me.Controls("fr m_SubFormName") .Form.ControlNa me

All of these worked when navigating the form normally but not when try
to find a record when the field selected was on the Tab Control.

Has anyone come across this before? I would be grateful for any
assistance offered.

Kind regards
Tim ffitch
Nov 13 '05 #1
0 1147

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

Similar topics

6
2715
by: Shaun Fleming | last post by:
I've been trying to make this simple script compatible across various browsers. It works for IE 6.0 and NS 7 but doesnt work with Opera (I have version 7.11). This is what is supposed to happen: when the user clicks a button in the main window, a dialog window pops up. In the dialog the user enters a university to search for. When the string is submitted, the dialog then shows all the matches found in the database. The user picks one and...
2
367
by: John | last post by:
Hi Is there a way to bring up find dialog through code while on an access form? Basically I want the find dialog to come up immediately after the form is loaded. Thanks Regards
7
1481
by: amazo | last post by:
Dear all, A new network has been installed on a customer and I get some troubles to do specific things; I will explain: The infraestructure is as follows: .. Server: Windows Server 2003 .. Workstations: Office XP Pro I have installed ACC97 on "each" workstation using a login with
2
1503
by: Lumpierbritches | last post by:
Thank you in advance for any and all assistance. I'm trying to create a report that will work similar to the label wizard in Access. I have a premade form I'm attempting to fill with data from the db. I can manually make the information fit, by making the report the full 8.5" x 11", however, when I attempt to size the report so that an individual record prints in each one, the sizing is all off. Is there a secret for dividing up the report...
5
2892
by: MLH | last post by:
Having identified a A97 bug in which acDialog causes undesirable side effects processing the opened form, I would like to replace the following code running in MyForm ... DoCmd.OpenForm "frmVehicleChooserForm", , , , , acDialog .... (more code I want to run after suspension) With this new approach... DoCmd.OpenForm "frmVehicleChooserForm", , , , , , ThisForm Me.Visible = False
0
1397
by: ApexData | last post by:
Hello I launch the Find Dialog Box from a button on a form. How can I determine specifically when the Find Dialog Box is no longer being displayed? This will allow me to control my Button Availability which is giving me a problem because the OnCurrent code is invoked before the FindDialogBox leaves the
0
1425
by: ApexData | last post by:
I Want Access FIND&REPLACE to stay in FIND mode. Can I place the (Access FIND&REPLACE Dialog) in a popup/modal dialog form? I need to control this process to prevent the user from pressing keys on the MainForm that will cause the Forms AllowEdit to become True, in-turn putting REPLACE back on! I DONOT want this to happen.
2
2341
by: planetthoughtful | last post by:
Hi All, I'm building some reports in Acc97 and using a custom calendar form to allow users to pick dates with which to report. I'm wondering if there's an easy way in code to be able to automatically work out the end-of-week date and end-of-month date from an arbitrary date value? To explain a little further. Let's say a user wants to view a weekly
6
2218
by: John | last post by:
In a form how I can I trap for the action that a user opens the built in 'find dialog'? I would like to trap for it and before the dialog shows up, I would like to execute some code, and after that I would like to bring up the 'find dialog'. thanks, john
0
8407
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
8319
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
8837
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...
0
8739
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6175
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
5638
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();...
0
4171
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4329
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
1969
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.