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

Home Posts Topics Members FAQ

continous form

How do i create continous form i created main form with subform drag
and drop into main form but the subform shows me the 1st record of the
customer . how can i link main form with subform i tried to search web
but in vain.

Please Help.

Apr 20 '07 #1
2 1711
access baby wrote:
How do i create continous form i created main form with subform drag
and drop into main form but the subform shows me the 1st record of the
customer . how can i link main form with subform i tried to search web
but in vain.

Please Help.
If you click on the subform and open the property sheet for it you will
see where you can link the subform's foreign key to the main form's
primary key under the Data tab. Click on the link row and press the ...
triple dot on the right.

Apr 20 '07 #2
On Apr 20, 8:40 am, salad <o...@vinegar.c omwrote:
access baby wrote:
How do i create continous form i created main form with subform drag
and drop into main form but the subform shows me the 1st record of the
customer . how can i link main form with subform i tried to search web
but in vain.
Please Help.

If you click on the subform and open the property sheet for it you will
see where you can link the subform's foreign key to the main form's
primary key under the Data tab. Click on the link row and press the ...
triple dot on the right.
Thanks It works

Apr 20 '07 #3

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

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...
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
5
4549
by: Nothing | last post by:
I have a search results form that is being displayed as a continous form. I want to double click the name and then using VBA select the different columns of information. For Example: Name City DL# Last Bid# Michael Toledo Unknown 139 Robert Cleveland 123456 254
1
2035
by: Karl | last post by:
I have a continous form based on 1 table. On the form I have a button that sets the OrderBy to as follows DataSource = Me.RecordSource If Me.OrderBy = DataSource & ".PaymentDate DESC" Then Me.OrderBy = DataSource & ".PaymentDate" Exit Sub End If
1
2839
by: Kev | last post by:
Hi, I am trying to total a column (Shift1) in a subform (continous forms) from the after update event of the (Shift1) column control within the subform. This column stores shift codes, I want to sum the hours associated with these shift codes from the RosterShifts Table. ie. Shift1 may = D The D shift is 8 hours long I am using Dictionary objects within the form as suggested by Gord,
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
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
10586
Oralloy
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...
1
10323
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,...
0
10082
tracyyun
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...
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?
1
4301
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
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.