Format problem using combo box

[Qsol]

I have a autonumber field with a prefix: "EXP"00000 in a table
This number should be transfered to another table in a field using number
format as described in the manual inorder to make a join.
In the selection form I have a combo box selecting from the first table
saving in the next table.

When I select EXP00001 I get an error: "The value do not fit the field. You
migth have entered text into a numerical field or the number is too large.

If I type "1" into the box it shows "EXP00001" and this is also shown in the
reciever table.
What is wrong?

 

[Wayne-I-M]

Hi

"EXP"00000 is not an autonumber it is a calculated result (text) so you
can't link this with a number field in another table.
The reason why it works when you enter 1 is that it is finding the number 1
- numbers can not have any "0's" in front of them.

What you could do is to create an autonumber field
1,2,3,4,5 etc
Then, in a querry prefix the EXP and any number of 0's you want.
Then create a combo in you form with 2 column based on this query.
1st column (bound column) is based on the auto number and the 2nd column is
based on the prefixed text (eg. EXP0000123). set the column widths to 0cm;2cm
You then serach the combo for the prefixed text.
You can use the wizard to create this for you - base the combo on your new
query.