473,804 Members | 3,958 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

go to last form (continous form view)

51 New Member
i have a form and subform...
i have combo box on main form that has combo box to filter a record to be shown on subform...

the case now is ,

is it possible the on load or after select a record from my combo box, the cursor should be on the last or new record or should i say "last form" of my subform contents,(subfo rm shows continous forms)

tnx
May 4 '07 #1
2 1574
pks00
280 Recognized Expert Contributor
Do you mean you want to go to the last record displayed in the subform?

You could try this from the mainform - use the afterupdate event of your combobox to do this as u want this to happen when u make a change

Me.<<nameofmysu bform>>.SetFocu s
DoCmd.GotoRecor d , , acLast
May 4 '07 #2
JConsulting
603 Recognized Expert Contributor
private sub mycombo_AfterUp ddate()
Me.mysubform.fo rm.SetFocus
DoCmd.GotoRecor d , , acNewRec ' for new record
end sub

DoCmd.GotoRecor d , , acLast ' for last record
May 6 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

2
5140
by: JK | last post by:
Hi All, I am working a form which is tabular layout (continuous form) which will display multiple records at a time. Each line of record needs to be reflected on the color code to show their current status. In Access 2000, you can only write the code on each control in a general way and the code will apply on to the current record. For instance, if you have 5 customers in display, each one of them has difference balance, if you like to...
1
2332
by: adolph | last post by:
I would like to add a check box to the detail area of a continous form. So that I can check on specific records, then after I've marked all the records I watn to delte, click a button to loop thru these check boxes, if checked get the field with the underlying table record ID and run a query to delete it. I've built a continous form to show all the records. I now want to add a check box beside each record, so that I can check specific...
2
6615
by: IanCraft | last post by:
I am new to Access 2002 and have a questions regarding using a form for data entry. I have 15 items I need to keep track of that are listed individually on a form as follows: Item#1Name AmountOut AmountIn Item#2Name AmountOut AmountIn etc. Each day, the user opens this form and records the amount they have taken or put in for each of the 15 items. This form, when submitted,
0
1732
by: gavo | last post by:
Hi. using A2K; i have a form containing a continous subform. The question is, how can i call a calculation for one of the fields in the continous subform from the main form. At the moment i have a button on the main form that will call a public code containing the calculation i need, the problem i have is that it will only perform the calculation on the first record on the continous subform and i need it for all the records
0
1426
by: ReidarT | last post by:
I have started to develop in vb.net. Earlier development was in MS-Access. I need a lot of continous forms to present data. The customer add and edits data in the continous form. Is use of datagrid the way I should do it in vb.net? I need up to 1000 records in a continous form (mostly 3-400) regards reidarT
3
1780
by: questionit | last post by:
Hi Is it possible with the Continous Form to have the textbox properties changed to show either the first or the last record. Property changed could be change of font color, size ,etc. Thanks Qi
5
1629
by: googletired | last post by:
On my current site, I can click on a category and the view the content of that category. This is fine, but now I want to be able to view the contents of *ALL* the categories in one continous scroll seperated by category title. But I'm not quite sure how to go about it. My current code: <?xml version='1.0' encoding='utf-8' ?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <xsl:output method="html"...
2
1411
by: questionit | last post by:
Hi I know how to implement Continous form. In the method i have tried, the source for data on the continous form comes from table using SQL query Now, i want to try something different and i need your help. With the same continous form, i want the source for the data to be a simple piece of code that returns names of files in the folder. I have completed working code for getting file names in the folder:
5
2133
by: AccessHunter | last post by:
Hi, I have a continous form that displays Name and Address of Suppliers. In the form there is a combo box for 'Active Address' and 10 other text boxes. All the fields coem from one table, "Primary Suppliers". The combobox is for 'Active Address' with values 'Yes' and 'No'.Control source of the form is, Select * from PrimarySuppliers where ="Yes". I want the form to display only the Suppliers who has 'Active address' = "Yes".If user selects...
0
9707
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
9585
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
10338
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
7622
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
6856
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
5525
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
5658
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3823
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2997
bsmnconsultancy
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...

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.