itemdata

[Ted]

i'm a relative newbie, so please excuse me if this sounds
naive....

Private Sub Form_Current()

Me.CCRC_Number.Requery
Me.CCRC_Number.SetFocus
Me.CCRC_Number.Text = IIf(IsNull(Me.CCRC_Number.ItemData
(0)), " ", Format(Me.CCRC_Number.ItemData(0), "@@-@@@&"))

End Sub

is a module i created on a form's current property.

the bigger picture goes something like this.....

there are a pair of databases one of which we'll call 'A'.
it contains a form called 'Register Protocol' which
contains a field called "CCI_Number" which has an input
mask: "00\-000C;".

there is a 2nd database which we'll call 'B' which has a
link to the table where "CCI_Number" can be found on the
table "Protocol_Tracking".

in 'B', there's a table called 'Protocol' which has a
combobox which also called 'CCI_Number' whose row source is
"SELECT [Protocol_Tracking].[CCI_Number] FROM
Protocol_Tracking WHERE ((([Protocol_Tracking].[IRB
Number])=[Forms]![Protocol]![IRB_Number]));" with an input
mask: "00\-000C"

(the VBA code i pasted at the beginnins is in 'Protocol')

now, hopefully, i've accounted for the various components
involved in the process and my question has to do with
the 'Run-time error "2279"' that tells me "The value you
entered isn't appropriate for the input-mask '00\-000C'
specified for this field."

what've i done?

anyone out there?

 

[Bill]

the @ sign is being input where the input mask is requiring 0-9.....change
the input mask requirements to the & sign instead of 0 like
"&&\-&&&C"
HTH
(input mask property is likely in the table definition) or the forms control

 

[Ted]

much obliged to you, there bill.
i'll give it a try 'n see what happens

-----Original Message-----
the @ sign is being input where the input mask is requiring 0-9.....change
the input mask requirements to the & sign instead of 0 like
"&&\-&&&C"
HTH
(input mask property is likely in the table definition) or the forms control

i'm a relative newbie, so please excuse me if this sounds
naive....

Private Sub Form_Current()

Me.CCRC_Number.Requery
Me.CCRC_Number.SetFocus
Me.CCRC_Number.Text = IIf(IsNull(Me.CCRC_Number.ItemData
(0)), " ", Format(Me.CCRC_Number.ItemData(0), "@@- @@@&"))

End Sub

is a module i created on a form's current property.

the bigger picture goes something like this.....

there are a pair of databases one of which we'll call 'A'.
it contains a form called 'Register Protocol' which
contains a field called "CCI_Number" which has an input
mask: "00\-000C;".

there is a 2nd database which we'll call 'B' which has a
link to the table where "CCI_Number" can be found on the
table "Protocol_Tracking".

in 'B', there's a table called 'Protocol' which has a
combobox which also called 'CCI_Number' whose row source is
"SELECT [Protocol_Tracking].[CCI_Number] FROM
Protocol_Tracking WHERE ((([Protocol_Tracking].[IRB
Number])=[Forms]![Protocol]![IRB_Number]));" with an input
mask: "00\-000C"

(the VBA code i pasted at the beginnins is in 'Protocol')

now, hopefully, i've accounted for the various components
involved in the process and my question has to do with
the 'Run-time error "2279"' that tells me "The value you
entered isn't appropriate for the input-mask '00\-000C'
specified for this field."

what've i done?

anyone out there?

.