Fault in transferral of result from form to query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

MSF - 02 Nov 2007 12:32 GMT

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?

Signature

MSF

Reply to this Message

Jeff Boyce - 02 Nov 2007 15:53 GMT

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

> Hi,
>
[quoted text clipped - 8 lines]
>
> How do I fix this?

Reply to this Message

MSF - 02 Nov 2007 17:14 GMT

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

Signature

MSF

"Jeff Boyce" skrev:

> Perhaps there's a matter of terminology at work here.
>
[quoted text clipped - 28 lines]
> >
> > How do I fix this?

Reply to this Message