Mysteriously disappearing data

jcbnc

Registered User.
Local time
Yesterday, 20:20
Joined
Oct 25, 2012
Messages
18
I am working on updating several forms I have. One has a dropdown field that allows me to select the customer I want to see, however, when I select the customer from the dropdown field it seems to delete the customer name from the customer table, which is in another database. Please help!!!:confused:
 
What do you mean by "it seems to"? Did you look in the Customer table?
 
Oh yes, I looked in the Customer table and the Customer name is quite gone from there. It is an empty field.
 
So just by selecting a customer with this ComboBox, you erase the name from the Customer table? Do you have code in any events of the ComboBox and if so can you post it?
 
Apparently I am not allowed to post links yet.
 
<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><UserInterfaceMacro For="Company" Event="AfterUpdate"><Statements><ConditionalBlock><If><Condition>IsNull([Screen].[ActiveControl])</Condition><Statements><Action Name="StopMacro"/></Statements></If></ConditionalBlock><Action Name="OnError"/><ConditionalBlock><If><Condition>[Form].[Dirty]</Condition><Statements><Action Name="SaveRecord"/></Statements></If></ConditionalBlock><ConditionalBlock><If><Condition>[MacroError].[Number]<>0</Condition><Statements><Action Name="MessageBox"><Argument Name="Message">=[MacroError].[Description]</Argument></Action><Action Name="StopMacro"/></Statements></If></ConditionalBlock><Action Name="OnError"><Argument Name="Goto">Fail</Argument></Action><Action Name="SetTempVar"><Argument Name="Name">ActiveControlValue</Argument><Argument Name="Expression">[Screen].[ActiveControl]</Argument></Action><ConditionalBlock><If><Condition>[CurrentProject].[IsTrusted]</Condition><Statements><Action Name="SetValue"><Argument Name="Item">[Screen].[ActiveControl]</Argument><Argument Name="Expression">Null</Argument></Action></Statements></If></ConditionalBlock><ConditionalBlock><If><Condition>[Form].[FilterOn]</Condition><Statements><Action Name="RunMenuCommand"><Argument Name="Command">RemoveFilterSort</Argument></Action></Statements></If></ConditionalBlock><Action Name="SearchForRecord"><Argument Name="WhereCondition">="[CustomerID]=" & [TempVars]![ActiveControlValue]</Argument></Action><Action Name="RemoveTempVar"><Argument Name="Name">ActiveControlValue</Argument></Action></Statements></UserInterfaceMacro></UserInterfaceMacros>

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application"><UserInterfaceMacro For="Company" Event="OnGotFocus"><Statements><Action Name="OnError"/><ConditionalBlock><If><Condition>[Screen].[ActiveForm].[Name]=[Form].[Name]</Condition><Statements><Action Name="Requery"><Argument Name="ControlName">=[Screen].[ActiveControl].[Name]</Argument></Action></Statements></If></ConditionalBlock></Statements></UserInterfaceMacro></UserInterfaceMacros>
 
What environment are you working in?
 
I'm not sure how to answer that question. It is Access 2010, if that is what you mean.
 
Can you post any jpgs of your form(s), tables, relationships?
Are you working with macros? Is this a web application? Is Sharepoiint involved?
Can you tell us what the database is about? What tables are involved besides Customers?
Perhaps you could post a copy of your database with no private/confidential info--zip format. I think you can post if you use a zip file.
 
What I posted in my last entry was a copy of the macros that were associated with the drop down field. This is not a web application or on SharePoint. This database is for a small Tool company and it allows them to track their quotes and orders that they deliver to their customers. I have customers, employees, products, orders, quotes and then some tables and forms. I have the tables split out into a separate database and are linked in a database that has the forms in it. I started putting together a user guide for my client and it will give you the best information on the system.
 

Attachments

Users who are viewing this thread

Back
Top Bottom