473,327 Members | 2,071 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

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_sfrmCustInfo - 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_sfrmCustInfo shows address, phone from record #1 on
tblCustomers, NOT the customer I am working with.

I tried to create a new frmOrders_sfrmCustInfo and call it
frmNewOrder_sfrmCustInfo, 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 #1
10 1685
I don't know how You did your subform, but in making a subform into an
existing form when you click the subform wizard in the toolbox, the wizard
asks what fields do you want to connect. very easy, because even I managed
to do it... or else I misunderstood Your question...

-e-

"sara" <sa*******@yahoo.com> kirjoitti
viestissä:11********************@g43g2000cwa.googl egroups.com...
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_sfrmCustInfo - 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_sfrmCustInfo shows address, phone from record #1 on
tblCustomers, NOT the customer I am working with.

I tried to create a new frmOrders_sfrmCustInfo and call it
frmNewOrder_sfrmCustInfo, 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 #2
I did that and the fields connected are CustID on both the main form
and the subform. But still I'm not getting the same customer
information on the sub and main forms. THe main form has the customer
I want; the subform has the first customer on file.

Help!!

Thanks

Feb 22 '06 #3
Is there a relationship between the tables?
-elli-

"sara" <sa*******@yahoo.com> kirjoitti
viestissä:11**********************@g43g2000cwa.goo glegroups.com...
I did that and the fields connected are CustID on both the main form
and the subform. But still I'm not getting the same customer
information on the sub and main forms. THe main form has the customer
I want; the subform has the first customer on file.

Help!!

Thanks

Feb 23 '06 #4
Yes, one customerID (CustID) to many orders. CustID is on the order
table.

What does this tell us?

I have the custId hidden on both the main and the subform. Both show
the same custID - 26 in the current test.

BUT, you have me thinking here.....The form I'm having trouble on is
NEW ORDER. SO, I can see the info on all other forms (I think; I'm
checking that too), but I'm guessing on NewOrder it might have
something to do with the relationship? There actually isn't a record
on the Order table until the user enters data.

Your question brought me to this point, but if this is the issue, what
would I do about it? Pull the data from somewhere else?

I could probably figure out how to do that, like hide (select the
fields in the list box, but give them 0 width) them on the main form.
The main form is the one I use to get the CustId, which works fine. I
have 2 functions; 1 to get the custID from the main form and another to
use that custID and retrieve the customer name from the main form.

Your thoughts?

Thanks so much. I'm actually feeling a little better about this!
Sara

Feb 24 '06 #5
If you already have a form that shows users and orders and that works fine,
why not just add new order directly to that form?
Am I missing something?
-elli-
"sara" <sa*******@yahoo.com> kirjoitti
viestissä:11*********************@i39g2000cwa.goog legroups.com...
Yes, one customerID (CustID) to many orders. CustID is on the order
table.

What does this tell us?

I have the custId hidden on both the main and the subform. Both show
the same custID - 26 in the current test.

BUT, you have me thinking here.....The form I'm having trouble on is
NEW ORDER. SO, I can see the info on all other forms (I think; I'm
checking that too), but I'm guessing on NewOrder it might have
something to do with the relationship? There actually isn't a record
on the Order table until the user enters data.

Your question brought me to this point, but if this is the issue, what
would I do about it? Pull the data from somewhere else?

I could probably figure out how to do that, like hide (select the
fields in the list box, but give them 0 width) them on the main form.
The main form is the one I use to get the CustId, which works fine. I
have 2 functions; 1 to get the custID from the main form and another to
use that custID and retrieve the customer name from the main form.

Your thoughts?

Thanks so much. I'm actually feeling a little better about this!
Sara

Feb 24 '06 #6
For their a customer's first order, there would be no form that shows
their order.

This app is for a friend who has never used a computer. I have limited
development skills, so we're a match!

She is interested in learning, but it's hard when you run a business
basically by yourself. There is one guy who works part time with her,
and I hope he'll learn too.

SO, I've made it very simple - really for both of us. One thing on a
form, basically. You see all the customers (there are about 2000) and
then you can choose to see their garments, or their orders. If the
customer is new, you can add a customer.
From garments, you can view, edit or add. Or, you can click a button

to go to orders. etc. Very simple. Also, I work full time so I can't
be there for my friend all the time, (and she doesn't have any internet
connection, so I can't dial into her machine to help her), so I wanted
something that is simple.

Long story, but that's the reason.

Your question from last night got me thinking and I fixed the problem
by putting all the data "hidden" on the main form. Works great now. I
am still interested in a better way to do it, if there is one, but am
Very happy it works!

Is there a better way?
Thanks
Sara

Feb 24 '06 #7
There is a better way, but it becomes a bit more difficult to do:

Place a combobox on the form to look up the customer and unbound text
boxes for the customer info and a listbox for the order information. In
the AfterUpdate event of the combobox, select the customer information
from the customer table and fill the textboxes with their relevant
information. You might want to put a textbox (visible=false) on the
form and then fill it with the primary key (or the value of the
combobox AfterUpdate) for the selected customer record for later use.
Select all the orders for the selected customer and populate the
listbox with this data.

It is really easier not to open a new form to enter new order data.
Just have a textbox where the new order number has to be entered and
then check if that order number has been used and fill the form with
that data if the order exsists. I have a sample db somewhere that
basically does the above mentioned, if you want to take a look at it.

Feb 24 '06 #8
Thanks, Helga, for the explanation. I'll try it, though it will
probably take me a while to figure it all out. A sample db would
probably help some, if it is available. How do you do that? Email it
to me? Not sure on the protocol here, as I'm a newbie.

Thanks
sara

Feb 24 '06 #9
I will send you a sample db. It was created quickley and some of the
form repaints don't work properly yet.

Mar 2 '06 #10
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
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:...
4
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:...
4
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...
0
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...
1
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...
17
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...
7
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...
3
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...
5
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...

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.