HI, i am trying to pull together a form that has a sub form, my master form has my customer info with a combo box, which the master form is based off a qry, i also have a sub form within this master form, that is pulling from a qry that has the orders that have not been paid, all my qrys run fine and give correct info, my issue is that when i open my master form, it auto fills the customer id with the first customer id that is in my qry list of unpaid orders, and no matter what name i put into the combo box, it does not change the custoemr id, and there for it wont change the sub for to refelect he correct unpaid order. i have watched invociing video, all expert levels, etc. i have messed with how the querys are joined, etc. cant quite seem to figure out what is no working correctly so when i select the custoemr name fro mthe combo box, and it changes the custoemr id in the master field..