changing text to numeric

[Guest]

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!

 

[Ken Snell \(MVP\)]

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).

 

[Guest]

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\)]

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?

 

[Guest]

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\)]

I apologize... I've been out of town on business and didn't have a chance to
reply. I will do so as soon as possible.

 

[Ken Snell \(MVP\)]

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?