Hi all,![]()
i have one Access on which i have ComboBox when i select the value in combobox it bind the othere control's in subform1 there is one LocationID TextBox on this subform1, now i want to featch (Retrive) value from depends on this LocationID and display it in SubForm2 on same form how can i do this ??
IS THIS POSIBLE TO RETRIVE THE VALUE FROM DATABASE BY WRITING THE USER DEFINE SELECT STATEMENT ???
LIKE
"SELECT * FROM SHIPTOLOCATION WHERE CUSTOMERID IS txtCustomer.Text" ???
pls Help me regarding this ??
thanx in advance





Reply With Quote