majid.pervaiz
Registered User.
- Local time
- Today, 05:46
- Joined
- Oct 15, 2012
- Messages
- 110
Dear All,
I have a form which has certain drop-down, based on the value in drop-down I am concatenating them to a new field.
the below is the code but it is giving me an error on serial "Expected : End of statement"
Me.Ref_No.Value = Cntry & "/" & Ctgry & "/" & Lng & "/" serial
please note that serial is also a text field but there is no drop-down on the form for serial but yet I did the below in code
Dim Cntry As String
Dim Ctgry As String
Dim Lng As String
Dim serial As String
serial = Me.Serial_No.Value
appreciate your expert advise
other thing for my knowledge, if the data type of serial_no field is number can we concatenate also ? like by & "/" me.serial_no.value
I have a form which has certain drop-down, based on the value in drop-down I am concatenating them to a new field.
the below is the code but it is giving me an error on serial "Expected : End of statement"
Me.Ref_No.Value = Cntry & "/" & Ctgry & "/" & Lng & "/" serial
please note that serial is also a text field but there is no drop-down on the form for serial but yet I did the below in code
Dim Cntry As String
Dim Ctgry As String
Dim Lng As String
Dim serial As String
serial = Me.Serial_No.Value
appreciate your expert advise
other thing for my knowledge, if the data type of serial_no field is number can we concatenate also ? like by & "/" me.serial_no.value