Hi,
I have a form which contains a subform. When I'm entering data into
the subform it seems to requery automatically. When this occurs the
focus goes to the start of the subform.
Firstly, do subforms requery automatically?
....and if so
can this be stopped?
My thanks in advance
Lui
3  3443 
No, something in one of the events on the subform must be creating the
requery or refresh.
If you cna't find it, then post all the code from the subform here.
On Apr 5, 9:46 am, "LROCCO" <l_a_ro...@yahoo.co.ukwrote:
Hi,
I have a form which contains a subform. When I'm entering data into
the subform it seems to requery automatically. When this occurs the
focus goes to the start of the subform.
Firstly, do subforms requery automatically?
...and if so
can this be stopped?
My thanks in advance
Lui
On 5 Apr, 16:11, "Jason Lepack" <jlep...@gmail.comwrote:
No, something in one of the events on the subform must be creating the
requery or refresh.
If you cna't find it, then post all the code from the subform here.
On Apr 5, 9:46 am, "LROCCO" <l_a_ro...@yahoo.co.ukwrote:
Hi,
I have a form which contains a subform. When I'm entering data into
the subform it seems to requery automatically. When this occurs the
focus goes to the start of the subform.
Firstly, do subforms requery automatically?
...and if so
can this be stopped?
My thanks in advance
Lui- Hide quoted text -
- Show quoted text -
Thanks for the reply.
The odd thing is it even seems to refresh/ requery when the user is
not operating the database, i.e. just looking at it??
On 5 Apr, 16:11, "Jason Lepack" <jlep...@gmail.comwrote:
No, something in one of the events on the subform must be creating the
requery or refresh.
If you cna't find it, then post all the code from the subform here.
On Apr 5, 9:46 am, "LROCCO" <l_a_ro...@yahoo.co.ukwrote:
Hi,
I have a form which contains a subform. When I'm entering data into
the subform it seems to requery automatically. When this occurs the
focus goes to the start of the subform.
Firstly, do subforms requery automatically?
...and if so
can this be stopped?
My thanks in advance
Lui- Hide quoted text -
- Show quoted text
thanks for the response
It seems quite odd as the form even refreshes/requeries when no one is
operating it?? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Dave Boyd |
last post by:
Hi,
I have two very similar forms each with a subform. The main form gets
a few fields from the user and passes this back to a query that the
subform is bound to. The requery is done when the...
|
by: F. Michael Miller |
last post by:
I need to requery a subform from a third form and can't seem to get it to
work.
frmForm1 has frmAddress as a subform. The button cmdReviseAddress opens the
form frmUpdateAddress where all of my...
|
by: ken |
last post by:
Hi,
I have a main form with a text box and a filter button. I also have a
subform in the main form. When I make an entry into the filter text box
and click the filter button, I change the query...
|
by: Kurt |
last post by:
I have an unbound main form with an unbound subform.
frmProjects
fsubProjectList
Using combo boxes, the user can select several search criteria on
frmProjects and then click a command button....
|
by: Parasyke |
last post by:
I have a subform within a tabpage that will requery/refresh (?) if I
press F9 and it will update the data in the subform, but I have tried
various combinations of Me!SubformName.requery...
|
by: midlothian |
last post by:
Hello,
I have conditional formatting set up on a subform based on a calculated
value in the underlying query. For instance, if Sales are >$1000, the
query displays "Yes," otherwise it displays...
|
by: MarkoBBC |
last post by:
Hi everyone,
First a brief description of my form: I have a subform within a main form. In my subform, I have a listbox displaying address information by firm name. A user first has to select a...
|
by: mrowe |
last post by:
I am using Access 2003. (I am also using ADO in the vast majority of my code. I recently read a post that indicated that ADO is not all that is was initially cracked up to be. In the back of my...
|
by: mslagle1 |
last post by:
Hi all,
I am trying to requery a subform "frmOpenWorkOrders" when a value list "status" on my main form "frmWorkOrderMain" is changed. If I change "status" then click on "frmOpenWorkOrders" and...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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
|
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...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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: 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: 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,...
|
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,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
| |
