Fault in transferral of result from form to query

M

MSF

Hi,

What is wrong?
In a form I have a combo box - when a choice has been made the result should
be saved i the query (where it is defined). It works partly

The result from the form - 2155931
the result in the query - 215 (the last 4 numbers dissappers)

How do I fix this?
 
J

Jeff Boyce

Perhaps there's a matter of terminology at work here.

In Access, data is stored in tables, not in forms, and not in queries.

On your form, is your combo box "bound" to any field? (You did mention
something about a query, so which field from the query is it bound to?) If
you open the query in design view, check the properties of that field --
what data type and what decimal places property?

A query is based on a field in a table. Go to the table in design view.
Find the field and check the properties here, too.

Finally, check the form in design view. Do you have any code running
"behind the form"? Is it affecting this field?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
M

MSF

Hi experts,

I guess I did not explain my self clearly. I'll try and illustrate:
BEHIND FORM
table 1 table 2
x text = x text
y text z number (standardvalue=0)

BEHIND COMBOBOX
table 3
z number
a text
b number

when a choice have been made in the combobox it should be saved in z.
I have checked the properties between the fields - they match, so the
problem ishouldn't be there.

Hope you can point me in the rigth direction. (I havent got VBA codes
running behind the form.)

regards
 
Top