Entering info in one field brings up info in another field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Harry - 05 Mar 2008 15:45 GMT

I have a problem where after I created this form, I entered data in one field
and for some reason, data in another field pops up automatically. The strange
thing about it is the field that pops up comes from another table. So the two
fields are unrelated.

By the way, the field where the information pops up has a Dlookup command
for another field in the form, that is also unrelated to the first field.

To give you a better understanding of this I will give you an example.

I have fields WorkDay, ClientID, and CompanyName. WorkDay is unrelated to
the others. ClientID is related to CompanyName by means of a DLookup command.

When I type in data into the WorkDay field (which comes from tblLaborHours,
data in the CompanyName field (which comes from tblCustomers_Info), shows up.
Why is this?

Thanks for your help.

Reply to this Message

NetworkTrade - 06 Mar 2008 15:01 GMT

probably vba behind the scenes

if you don't want the field then delete it or make it not visible

if you need the field to be blank and not auto updating - you need to find
the cause and deactivate; one way is to change the name of that field that
is auto updating and then when you next try it there should be an error
thrown that will pull up that code...

just a guess though....

Signature

NTC

> I have a problem where after I created this form, I entered data in one field
> and for some reason, data in another field pops up automatically. The strange
[quoted text clipped - 14 lines]
>
> Thanks for your help.

Reply to this Message