I'm sure there is a workaround for this, but haven't found it yet. I
have a mainform with two subforms and after one or both of the
subforms are updated, then clicking the Refresh button on the mainform
(to show updated values), causes the updated subform(s) to
automatically scroll up to one blank line if a new record was entered,
or to the line that was edited. All of the prior subform records are
not viewable or accessible until exiting the mainform and returning.
If no updates to the subforms are done, then clicking the Refresh
button on the mainform causes no changes.
Have also use variations of Requery in lieu of Refresh for the
mainform, but had the same results to the subforms. A point of
clarification regarding this matter is that the subforms are
continuous forms with about 12 lines displayed - there is no change in
what is shown whether there have been updates performed or not, after
clicking the mainform refresh/requery button, until the data on either
one or both of the subforms exceeds the initial 12 lines.
Would using SetFocus somehow resolve this issue? Any assistance will
be appreciated. Thanks, Dalan 0 1922 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: P Mitchell |
last post by:
Hello
I would like someone to be able to help with the updating of data in a
lookup list in a subform. In short, is their a VB instruction that is the
equivalent of performing the action of going to the menu and selecting
Records and then Refresh?
or
To explain, based on a three table system where cars participate in rallies,
|
by: Tim Marshall |
last post by:
Here's the situation. A form, frmSetUp, with a subform control called
subExplain with a source object form frmSetUpSubDefineSides. The source
object is a bound form, displaying a few records, no edit, adds,
filters, etc, are permitted on the subform.
An add or edit button on the subform is clicked opening an unbound form,
frmSetUpSideAdd, (populated with values from the above subform if this
is an edit of an existing record) for data...
|
by: Greatmaze |
last post by:
Hi All,
I want to update a column in my Users table through a subform.
I have made a mainform where you can choose a Department (from
Department table), then a subform pops-up showing the users in that
Department.
Now I want to make 2 buttons on this subform to pop-up new (sub)forms
to add or delete a user to/from this Department, but this DepartmentID
must be updated in the User table, how can I fix this and how do I
refresh the first...
|
by: S. van Beek |
last post by:
Dear reader,
I have a Form with a SubForm.
On the MainForm there is a field receiving his content from a group query.
If a change or append or delete a record in the SubForm the group query will
cam up with another value.
|
by: MLH |
last post by:
I have frmVehicleEntryForm and on it is frmAddnlOwnrListSubForm.
The subform is unbound and lists records in a table, allowing the
user to change values in CheckMark controls on the subform as
desired.
I have another button that will allow user to run a query which will
update the field values related to the checkmark control to False.
To be sure the changed values show up in the subform control, I'm
thinking of running a line like the...
| |
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
Me!Forms!Subformname.requery, etc. to put the F9 functionality into VBA
code but nothing seems to work... any ideas? Thanks!
|
by: SBC News Groups |
last post by:
I have a form that the user enters some information on and then clicks a
button to save the record. I do with the following line:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Once this line executes, I have a sub form that I want to "refresh" because
the newly saved information should now display on the sub form. I am trying
to do this with this line:
Forms!.Requery
|
by: LROCCO |
last post by:
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?
|
by: Simon van Beek |
last post by:
Dear reader,
After same changes it is required to requery (refresh) query in a sub form.
The code below is not working:
|
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...
|
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,...
| |
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...
|
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...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
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...
|
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();...
|
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...
| |
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |