That error ("the value you entered isn't valid for this field.") suggests
that the Data Type of the PO_no field (in DI table) that is bound to the
combo box is NOT Number, but rather is Text or something else.
By chance, are you using a split database -- where the tables are in a
separate database file from the one with the forms?
--
Ken Snell
<MS ACCESS MVP>
"Irene" <(E-Mail Removed)> wrote in message
news:F7076B79-56ED-46C6-BCBC-(E-Mail Removed)...
> the row source type is table. row source is "SELECT details_material.PONO,
> details_material.DESCRIPTION FROM details_material WHERE
> (((details_material.DESCRIPTION)=Forms!f_del_instruction!material_size)
> And
> ((details_material.DELIVERED)=0)) ORDER BY details_material.PONO;". the
> details_material means the PO table i mention before. the control source
> is
> PO_no. the record source of the form is DI table. i did not set the
> validation rule for the combo box. the format of the combo box is
> "YL"0000.
> there are the detailst which you wanted. can you teach me how to do?
> thanks!
>
> "Ken Snell (MVP)" wrote:
>
>> What is the Row Source for the combo box? What is the Row Source Type for
>> the combo box? What is the Control Source for the combo box? What is the
>> Record Source for the form? What is the Validation Rule for the combo
>> box?
>> What is the Format for the combo box?
>> --
>>
>> Ken Snell
>> <MS ACCESS MVP>
>>
>>
>>
>> "Irene" <(E-Mail Removed)> wrote in message
>> news:256F540C-4BEB-4C4A-947D-(E-Mail Removed)...
>> >i have change the thing that you ask me to change. but when i'm go to
>> >the
>> > form. i click the combo box and select the PO no, it was come out an
>> > error.
>> > it say that "the value you entered isn't valid for this field." it say
>> > may
>> > be
>> > i have entered text in a numeric field or a number that is larger than
>> > the
>> > fieldSize setting permits. i have follow the exact what i'm setting in
>> > the
>> > PO
>> > table. why it become like this? what can i do? can you help me?
>> >
>> > thanks!
>> >
>> >
>> > "Ken Snell (MVP)" wrote:
>> >
>> >> Open the DI table in design view. Click on the POP no field. Change
>> >> the
>> >> Data
>> >> Type to Numeric; then select the appropriate Field Size property at
>> >> bottom
>> >> of screen (likely, you'll want Long Integer, but you must make it the
>> >> same
>> >> as what it is in the PO table).
>> >>
>> >> --
>> >>
>> >> Ken Snell
>> >> <MS ACCESS MVP>
>> >>
>> >>
>> >> "Irene" <(E-Mail Removed)> wrote in message
>> >> news:78D1E8B6-A119-4FFC-AFFF-(E-Mail Removed)...
>> >> >i have two table. one is PO table and one is DI (delivery
>> >> >instruction)
>> >> >table.
>> >> > i have make a form and using DI table as the control source. then i
>> >> > make a
>> >> > combo box to look up the PO no. that combo box i'm using the PO
>> >> > table.
>> >> > cos
>> >> > i
>> >> > want to look into the PO table to see which PO i want to call in the
>> >> > material
>> >> > from the supplier. after select the PO no from the PO table i will
>> >> > keep
>> >> > the
>> >> > data in the DI table. PO no from the PO table was change from number
>> >> > field
>> >> > to
>> >> > text field when in the DI table. can i make the PO no as number
>> >> > field
>> >> > in
>> >> > DI
>> >> > table? how? cos i need using the PO no which is in the DI table to
>> >> > link
>> >> > with
>> >> > other table which is the PO no is as number field. anybody can help
>> >> > me?
>> >> >
>> >> > thanks!
>> >>
>> >>
>> >>
>>
>>
>>
|
Similar Threads
