Combo box problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using this
SELECT CreditCardInfo.CreditCardInfoID, CreditCardInfo.CreditCardType,
CreditCardInfo.CardholdersName, CreditCardInfo.CreditCardNumber,
CreditCardInfo.CustomerID, CreditCardInfo.CreditCardExpDate
FROM CreditCardInfo
WHERE (((CreditCardInfo.CustomerID)=[Forms]![PaymentsForm]![TextCustID]))
ORDER BY CreditCardInfo.CreditCardNumber;
In a combo box on a sub form. When I open and run it manually from query
window it works. When I try from the subform it asks for
[Forms]![PaymentsForm]![TextCustID]. TextCustID is on main form. When I use
=[Forms]![PaymentsForm]![TextCustID] as control source in an unbound text box
on subform it shows correct number. So I tried using this unbound text box as
crtieria in combo box and that didn't work either.
I would appreciate any suggestions on what else to try. Thanks
 
Back
Top