|
| | | Forum Newbie
Group: Forum Members
Last Login: 8/23/2008 10:35:01 AM
Posts: 6, Visits: 18 |
| | hi guys, my prob is how to get the customer id and the complete address as "address" when i select a name from the combo box from the Order form, imma include my project here, please try to see the error, x_x thanks. http//sydneyk.sitesled.com/Data.zip |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 10/18/2008 12:36:39 AM
Posts: 8, Visits: 59 |
| Dear readingline
Make some corrections in the Forder form and the results will be as reqd. First FuncInitialGrid is not reqd in Form_Load as it is already used in funcPopGrid. Second modify statement in cboCust_Click routine as below:
'strSQL = "Select customer_id,customer_address & ',' & city & ',' & state as address " & _
'since state field doesn't exist in T_Customer table so error "No value
'given for one or more item..." occurs at line RST.Open
'Modifiy above statement as below :Smartchap
strSQL = "Select customer_id,customer_address & ',' & city & ',' & province & ',' & zip_code" & _
" from T_Customer WHERE customer_name = '" & cboCust & "'"
and you will get the results. If any other query please ask. Also if problem solved please tell.
Always Believe in God.
Always Believe in GOD! |
| |
| | | Forum Newbie
Group: Forum Members
Last Login: 9/10/2008 4:46:08 AM
Posts: 3, Visits: 1 |
| | |
|
|