By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,663 Members | 1,791 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,663 IT Pros & Developers. It's quick & easy.

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

P: n/a
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
Share this Question
Share on Google+
10 Replies


P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
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 discussion thread is closed

Replies have been disabled for this discussion.