jerry28ph

hey can you help me with my school project

Sorry,

Didnt check the forum lately, you can try the Left(), ex. me."your textbox" = left("your control box",4). If you want to display only the first 4 string in your control.

Paki cc mo nlang sa e-mail ko yung mga questions, minsan wala nang time para mag view. otnobj@yahoo.com

Hope this helps!
Jepoy

SELECT tab_customer.po_cust, tab_customer.po_date, tab_customer.po_number, tab_customer.po_error, tab_customer.po_note
FROM tab_customer
WHERE (((tab_customer.po_cust)=[forms]![Form1]![cboCustomerCode]) AND ((tab_customer.po_date) Between [forms]![Form1]![txtStartDate] And [forms]![Form1]![txtEndDate]));