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