Control Source Problem

[Sondra]

I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
..

 

[Ken Snell]

= "CM020-" & Format([Year],2) & "-" & Format([CM_Number],000)

 

[Guest]

I used your suggest and it just continues to error out.

-----Original Message-----
= "CM020-" & Format([Year],2) & "-" & Format ([CM_Number],000)


--
Ken Snell
<MS ACCESS MVP>

I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
.

.

 

[Ken Snell]

Which error?

--
Ken Snell
<MS ACCESS MVP>

I used your suggest and it just continues to error out.

-----Original Message-----
= "CM020-" & Format([Year],2) & "-" & Format ([CM_Number],000)


--
Ken Snell
<MS ACCESS MVP>

I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
.

.

 

[Ken Snell]

Noted that I didn't add all the correct " characters. Try this:

= "CM020-" & Format([Year], "00") & "-" & Format([CM_Number], "000")
--
Ken Snell
<MS ACCESS MVP>

I used your suggest and it just continues to error out.

-----Original Message-----
= "CM020-" & Format([Year],2) & "-" & Format ([CM_Number],000)


--
Ken Snell
<MS ACCESS MVP>

I have the following Control Source and its giving me an
error can someone tell me where I have written it wrong???

= Right("CM020-"&Format([Year],2)&"-"&Format
([CM_Number],000))

Ultimately I want:

CM020-03-001
CM020-03-002
CM020-03-003
etc.

Thanks in advance.
.

.