Entering info in one field brings up info in another field

H

Harry

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

NetworkTrade

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top