Compile Error Expected: end of statement

[dallnsn]

Hi Everyone,

I am having trouble in VBA putting two different derived fields into a string. The coding I am using is calling details from a subform, and I have enclosed what I am trying to do below.

strMessage = "Warning: The recorded stock holding of" & Me.Description "is" & Me.StockHolding

I keep getting a Compile Error Expected: end of statement with the "is" highlighted.

Description is a book title, and stockholding is the number of inventory Items.


If anyone can offer assistence, it would be greatly appreciated.



Thanks.

 

[dallnsn]

Hi Everyone,

I am having trouble in VBA putting two different derived fields into a string. The coding I am using is calling details from a subform, and I have enclosed what I am trying to do below.

strMessage = "Warning: The recorded stock holding of" & Me.Description "is" & Me.StockHolding

I keep getting a Compile Error Expected: end of statement with the "is" highlighted.

Description is a book title, and stockholding is the number of inventory Items.


If anyone can offer assistence, it would be greatly appreciated.



Thanks.

 

[Rich]

& " is" & & Me.StockHolding

 

[dallnsn]

Thanks for your quick reply, but I am still getting the same error. Here is a paste

If Me.Dispatch > Me.StockHolding Then
strMessage = "Warning: The recorded stock holding of " & Me.Description " is" & & Me.StockHolding
strTitle = "Alert"

 

[dallnsn]

Thankyou, I had just missed out on a simple little & symbol in my programming, and after your help. IT WORKS IT WORKS..


Thankyou RICH

 

[CyberLynx]

strMessage = "Warning: The recorded stock holding of " & Me.Description & " is " & Me.StockHolding

.

 

[CyberLynx]

DOH! .... A double post

.