473,785 Members | 2,720 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Subform Displays Data from Record #1 (not current customer) - HELP!!

Hi -
I am developing a simple app, and just found a problem that I can't fix
after 4 hours of trying.

I display a list of customers, and the user chooses one and displays
"orders".

The frmOrders displays correctly, with the subform -
frmOrders_sfrmC ustInfo - on top that is correct. The subform displays
cust info - name, address, phone. Name is from a function that takes
the CustID and gets the name to display. The CustID field is hidden,
also uses a function to take the CustID off the initial form.

The Problem: When I choose "New Order" and open the "New Order" form,
the frmOrders_sfrmC ustInfo shows address, phone from record #1 on
tblCustomers, NOT the customer I am working with.

I tried to create a new frmOrders_sfrmC ustInfo and call it
frmNewOrder_sfr mCustInfo, but that didn't work. I thought I could
reuse the same subform, but I guess not.

My links are CustID and CustID, both fields exist. I have tried the
field name txtCustID as link and that doesn't work.

My subforms are based on tblCustomers. No selection or query.

I suppose I could hide all these data fields in the first List box and
refer to it from the subform, but I feel like that is not the simplest
route. Seems like the subform should Always work - don't understand
why it does in some places and not in others.

Thanks so much - I can post other details; not sure what is needed to
figure this out since there's no code. I'm so lost right now; just
don't know where to turn!

Sara

Feb 22 '06
10 1728
I will send you a sample db. It was created quickly and some of the
form repaints don't work properly yet.

Mar 2 '06 #11

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

Similar topics

1
1690
by: ken | last post by:
Hi, I have a MainForm and a SubForm. I also have a popup form that is opened by a button click on the subform. On that form I want to set the main form and subform. to set mainform you do this: dim f as form f = forms("MainForm") ---this works
4
1515
by: ken | last post by:
Hi, I have a MainForm and a SubForm. I also have a popup form that is opened by a button click on the subform. On that form I want to set the main form and subform. to set mainform you do this: dim f as form set f = forms("MainForm") ---this works
4
11835
by: authorking | last post by:
I use the following code to insert a data record in to a datatable of an access database.But every time I execute the command, there will rise an exception and the insert operation can't be completed. here's the code: System.Data.OleDb.OleDbConnection hist_cnn = new System.Data.OleDb.OleDbConnection(); System.Data.OleDb.OleDbCommand hist_command = new System.Data.OleDb.OleDbCommand();
0
2328
by: meetmaruthi | last post by:
Hai i am searching a database (in ms access ) to validate user info.it has two fields username and password. here is the coding and i get compile error:Method or data member not found.please help Private Sub Command1_Click() Set ch = ADODB.Recordset Adodc1.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Microsoft Visual Studio\sruniep\ssp\db\user.mdb;Mode=ReadWrite|Share Deny None;Persist Security...
1
1199
by: Robert | last post by:
I have a form with two subforms on it. Both subs have the same table as a controlsource. SubformA is a continuous form that acts as an index. The second subform displays a single record with all the fields from the table that users can edit the records with. When a user clicks on a record in subormA (via a transparent button), I want that record to appear in subformB. Any suggestions? Thanks Robert
17
2605
by: lokidog | last post by:
I am trying to automatically transfer data from one textbox to another between subforms within a 'main' form. I put this code into the Gotfocus eventprocedure: Private Sub Date_GotFocus() If Len(Trim$(Me!.Value & "")) = 0 Then 'This checks for blank or space-filled date field - it will only transfer data if it has not already been entered. Me! = !!.!.! SendKeys "{F2}" SendKeys "{TAB}"
7
3428
by: FNA access | last post by:
I have a mainform that has a subform in the detail section and a subform in the footer section.(Both subforms are in datasheet view) When I click the navigation button to create a new record on the mainform. My subform in the detail section goes blank (this is what I want) but my subform in the footer section appears to have the data from the previous record displayed. When you click on the subform the data dissapears and displays blank. If...
3
1721
by: 6afraidbecause789 | last post by:
Kudos to anyone who can explain this one--how to duplicate a group of continuous records in a subform for use in a new subform PK ID. The 2 entry fields (combo boxes) in the subform are RoleID and StaffID, and the PK ID is StaffandIntsID. The subform's data is put into jtblStaffandInts, which joins a Staff and Intervention tables: So, here's what the data could look like in the table: StaffandIntsID InterventionID StaffID RoleID
5
3949
mseo
by: mseo | last post by:
hi, I have mainform with two cmdbuttons: 1- Save 2- Add Detail the mainform has subform which is set to invisible, if I click Add Detail the subform appears, if not and user clicked Save the fields in the mainform will move to new blank record without having any details what I need to do, when the user click save and the fields in the subform is not filled, In this case I need the save action (moving to next blank record) to be cancelled ...
0
9643
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
9480
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
10319
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...
0
10147
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...
0
9947
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
6737
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
5380
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
5511
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
3
2877
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.