Constant Error

[Alhakeem1977]

Hi All,

How can I fix the below error (Constant expression required)? As I want to get the value string column 1 from combobox.

Thanks in advance!

 

[theDBguy]

Interesting. You still use an A: drive? Do you, by any chance, have any missing references? Just curious...

 

[Alhakeem1977]

Interesting. You still use an A: drive? Do you, by any chance, have any missing references? Just curious...

Thanks for your earliest response.
This is another project, also I must use a centralized shared folder for another purpose.
I have checked the References there is no missing.

 

[Alhakeem1977]

 

[Alhakeem1977]

Sorry it must be without the full path but I got a syntax error

Const strXFDF As String = " & Me.cboForm.Column(1) & ".xfdf"

 

[theDBguy]

Sorry it must be without the full path but I got a syntax error

Const strXFDF As String = " & Me.cboForm.Column(1) & ".xfdf"

What do you get with this?

Debug.Print Me.cboForm.Column(1)

 

[Alhakeem1977]

What do you get with this?

Debug.Print Me.cboForm.Column(1)

I got the below error

 

[theDBguy]

I got the below error

View attachment 84546

Hmm, no, I mean, just enter that line by itself. Anyway, since you want to use a variable, you can't use a constant. So, try changing your code to this:

'Declare the XFDF file to use
Dim strXFDF As String
strXFDF = Me.cboForm.Column(1) & ".xfdf"

Hope that helps...

 

[Alhakeem1977]

Hmm, no, I mean, just enter that line by itself. Anyway, since you want to use a variable, you can't use a constant. So, try changing your code to this:

'Declare the XFDF file to use
Dim strXFDF As String
strXFDF = Me.cboForm.Column(1) & ".xfdf"

Hope that helps...

It works fine with no error.

Thank you so much!

 

[theDBguy]

It works fine with no error.

Thank you so much!

Sure thing! Good luck with the rest of your project.