I have a continious subform which is only visible when the main form gets open.
The subform has a text box which is locked for the user.In order to enter something into it, a user has to click a button which will open zoom view and anything entered into the zoom view and clicked on Save button would get saved in the subform.
The problem is that whenever the subform gets visible the focus is always on the first record,when a new record is added the control doesn't go to the new record.It always comes to the first record.A user has to always scroll the subform to see the new record he/she has added.
How do I make it so when I see the subform through main form it automatically brings up a new record to be entered and not record 1.
or
After adding a new record how the control will come to the new record instead of going to the record 1.
3 2036
Hi. If you set the subform's Data Entry property to Yes you will restrict the form to entry of new records only. Please note that your users will not be able to edit (or even to see) existing records using that form if you set Data Entry to Yes (or, equivalently, to True using VBA code).
-Stewart
But I need the existing records.Editing those records is not necessary.
Tell me one thing - is it possible to go to the last record of a continious form after inserting a new record?
NeoPa 32,579
Recognized Expert Moderator MVP
Yes it is.
Try out what's already suggested and you will see for yourself.
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: DD |
last post by:
Hi
I have built some forms and made my own forward and back buttons and
removed all the Access default navigation buttons..however now when
you come to the last field and tab,, it opens a new record. rather
than staying with the same..
I have tried various things and have had no success
any help please
DD
|
by: Edward S |
last post by:
I have a continious form which keeps automatically scrolling down when
it is loaded. This form's control source is a query that has 2 fields
and each is derived from a DSum function
How can I stop this scrolling and just have the data fill into this form
either instantly or atleast gradually fills in but not have atleast 6 to
7 times keeps filling in. This looks very poor to the user.
Appreciate if someone could point me in the right...
|
by: indigo |
last post by:
hi..
can someone suggest the best way to move data from one table to another.
i'm trying to do this mainly due to my own limitations with regard to
access.
i have a form which has various cells on a continious form.
at the end of each section there is a checkbox
is it possible to create an event that if that check box is clicked then it
moved that information from one table to another. the ovther table would be
an archive table
|
by: swingingming |
last post by:
Hi, in the NorthWind sample database, when clicking on the next
navigation button on the new order record with nothing on the subform
(order details), we got an order with nothing ordered. How can we
prevent this from happening?
Thanks.
ming
|
by: maiami2 |
last post by:
Hi Guys,
I'm very new to access and I've been trying to get the hang of it over the last few days, but I've become very confused with various aspects of how to code it.
Introduction:
I am using 3 tables for my data base at the moment. The first table is an ID table, which tracks IDs that are in use/taken. The second table is a queue, which has very little/limited information on a person. The third table is a log, which has much more...
| |
by: =?Utf-8?B?UmljaA==?= |
last post by:
In a database search application (vb2005), the user wants to be able to
scroll through records using the mousewheel. The data display form contains
textboxes for the main data and a datagridview for the detail data for each
main record. The form also contains btnBegining, btnPrevious, btnNext,
btnEnd.
In the btnNext.MouseWheel event I can increment/decrement the main data
currencymanager position of the main dataset (depending on...
|
by: prn |
last post by:
Hi folks,
I've got something that's driving me crazy here. If you don't want to read a long explanation, this is not the post for you.
My problematic Access app is a DB for keeping track of software test data. Each instance of a test is associated with a "test case", that is, a test item. Each test instance (or "run") may have a number of other characteristics too, such as browser used, OS (XP, Vista, Linux, Mac OSX, etc.), etc., but for...
|
by: arthur.dayton |
last post by:
I am using Access 2007. I'm trying to set the control on a
subform to the current time. My code is:
Private Sub Command7_Click()
With Me.
..Form.SetFocus
..Form!.SetFocus
RunCommand acCmdRecordsGoToLast
..Form! = Now()
End With
|
by: g_k_harrison |
last post by:
Hello, again. What a great resource for us beginners is this forum!
I've got another question...Even though the record selectors and
navigation buttons are removed from a form you can still advance to
the next record in a table after the last field is filled. Does anyone
have a method for preventing that happening? Maybe some way to send
the focus back to the first field on the form on the same record?
Many thanks for your help!
Greg.
|
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: 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: 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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
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: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |