Hello ppl , well now i am having a small problem it's prolly simple for some of you guys but ..it is kinda playing tricks with me,
well this is what i want to do , i want to create a combo box which has a group od customers names and when you click on a name it gives you the details of the customer , basically it auto_updates the form , i have 2 tables i have a Customers table and a Products Table from that i created a query with fields combined from the two tables, and called the new table Payments. In the Customers table i have the foreign key Product Id so as to indetify which product the customer took , so when i am in the payments form i only have a combo box on customers name so when i click on the customers name it should show me which product he took and blah blah blah but the form has refused to auto update i have used the wizard but i dont know if i am doing something wrong ,..ooh and i am not good with VBA so i cant hardcode it which is saddening , so can someone shed some light on this for me i would highly appreciate it
thx in advance