If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Entering info in one field brings up info in another field
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. |
#2
|
|||
|
|||
Entering info in one field brings up info in another field
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.... -- NTC "Harry" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|