If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Listbox on form
I am create a form in Access 2003. Currently the form only show order# if it
is textbox, but when i change it to list box then it will not show any result. The search criteria is base on the custID, if I entered the custID and it will display all of the order# and the order Date that related to the custID i just entered. I requery it but this does not work! SELECT table.[Order#] FROM Table WHERE ((Table.[CustID#])=Me.Form.CustOrderInf.Column(1)); search Text criteria field named: txtsearch Listbox named: Order# Form named: CustOrderInfo Can anyone help? |
#2
|
|||
|
|||
Listbox on form
=Me.Form.CustOrderInf.Column(1));
Are you sure you have the correct column, they start at 0 not 1. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "hoachen" wrote: I am create a form in Access 2003. Currently the form only show order# if it is textbox, but when i change it to list box then it will not show any result. The search criteria is base on the custID, if I entered the custID and it will display all of the order# and the order Date that related to the custID i just entered. I requery it but this does not work! SELECT table.[Order#] FROM Table WHERE ((Table.[CustID#])=Me.Form.CustOrderInf.Column(1)); search Text criteria field named: txtsearch Listbox named: Order# Form named: CustOrderInfo Can anyone help? |
#3
|
|||
|
|||
Listbox on form
either one will not work but I tried this instead
SELECT Table1.[Order#], Table.Cust# FROM Table1 WHERE (((table1.Cust#)=[Me]![txtSearch])); It founds the order# but when i want to open up the form it pop up the textbox for me to enter the cust# and then it find it and then open the form. I want it open the form and then do the search. Also, after it open and do another search the order# will not referesh at all still keep the previous search record. "Dorian" wrote: =Me.Form.CustOrderInf.Column(1)); Are you sure you have the correct column, they start at 0 not 1. -- Dorian "Give someone a fish and they eat for a day; teach someone to fish and they eat for a lifetime". "hoachen" wrote: I am create a form in Access 2003. Currently the form only show order# if it is textbox, but when i change it to list box then it will not show any result. The search criteria is base on the custID, if I entered the custID and it will display all of the order# and the order Date that related to the custID i just entered. I requery it but this does not work! SELECT table.[Order#] FROM Table WHERE ((Table.[CustID#])=Me.Form.CustOrderInf.Column(1)); search Text criteria field named: txtsearch Listbox named: Order# Form named: CustOrderInfo Can anyone help? |
Thread Tools | |
Display Modes | |
|
|