Subforms and displaying data

  • Thread starter Thread starter kicken18
  • Start date Start date
K

kicken18

ok I am having troubles with forms and subforms. I have a form which
displays my cusomter infomation and i want a drop down list at the top
with surnames, under this is all the customer details and under that
subform with all their orders.

Soi want to select a Surname from the combo boc, which then chjanges
all the cusotmer infomation, to that customer, and also shows all the
orders for that customer.

Currently all it does it change the details that are already showing
for the first customer, to the surname i choose in the combo box; so
like i have custoemr 1 showing, change the surname and it still shows
customer 1 but now they have a differnt surname. Anyone got any help,
or good links

thanks
 
ok I am having troubles with forms and subforms. I have a form whic
displays my cusomter infomation and i want a drop down list at the to
with surnames, under this is all the customer details and under tha
subform with all their orders.

Soi want to select a Surname from the combo boc, which then chjange
all the cusotmer infomation, to that customer, and also shows all th
orders for that customer.

One thing i did notice is that if use the mouse scroller it does al
change and work perfect and i think thats because im scrolling thoug
the Customer ID, but i just cant get it to work with the combo box's

Currently all it does it change the details that are already showin
for the first customer, to the surname i choose in the combo box; s
like i have custoemr 1 showing, change the surname and it still show
customer 1 but now they have a differnt surname. Anyone got any help
or good links

thank
 
Back
Top