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

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_SubFormName.Form.ControlName
Forms!frm_MainFormName!SubFormName!ControlName
Me.Controls("frm_SubFormName").Form.ControlName

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 1133

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

Similar topics

6
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:...
2
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
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 .....
2
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...
5
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...
0
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...
0
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...
2
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...
6
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...
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...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
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: 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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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...

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.