I am a newbie to access and this forum so be gentle.
I have included alot here to give as much detail as possible if it is too muxh tell me and next tiem I will do better.



I have been reading everything I can find but still cannot resolve my issue so here it goes:

In a Web Database

I have Info table that lists data in 4 columns:
  1. ID-auto generated
  2. Prod- text
  3. Acronym- text
  4. version- text
  5. RefCode- text (concantenated using Acronym+Version)
In a second table Details I am using a Form to collect additional data. I have ComboBox that queires the RefCode (#5) above.
Code:
SELECT TZ_Products_Version.ID, TZ_Products_Version.Prod_RefCode FROM TZ_Products_Version ORDER BY TZ_Products_Version.Prod_RefCode;
Now is where the problem starts. Using the MACRO Editor I have a After Update Embedded UI macro (shown below) to auto fill the version based on the value in the RefCode field.

This UI Macro Calls a Data Macro to get return the value.

For What ever reason I cannot get the <Argument Name="Value">[Prod]</Argument> to return any value. Every time I proceed I get that
Data mismatch in Criteria expression error.

If I change the argument to a exrpession with quotes like this it works <Argument Name="Value">"Show this vaue"</Argument>. But that is not what I want.

Is there somethng special I need to do to return data to a field from a web database?

Thanks for any help

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~
UI Macro
Code:
 
 <?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application">
<UserInterfaceMacro For="cboTZProductCode" Event="AfterUpdate">
<Statements>
<Action Name="RunDataMacro">
<Argument Name="MacroName">TZ_Products_Version.GetTZProductName</Argument>
<Parameters>
<Parameter Name="prmTZProductID" Value="[cboTZProductCode]"/>
</Parameters>
</Action>
<Action Name="SetProperty">
<Argument Name="ControlName">Text94</Argument>
<Argument Name="Property">Value</Argument>
<Argument Name="Value">=[ReturnVars]![retProductName]</Argument>
</Action>
</Statements>
</UserInterfaceMacro>
</UserInterfaceMacros>
DATA MACRO
Code:
 
<DataMacros xmlns="http://schemas.microsoft.com/office/accessservices/2009/11/application">
<DataMacro Name="GetTZProductName">
<Parameters>
<Parameter Name="prmTZProductID" Description="TZ Product ID"/>
</Parameters>
<Statements>
<Action Name="SetReturnVar">
<Argument Name="Name">retProductName</Argument>
<Argument Name="Value">Null</Argument>
</Action>
<LookUpRecord>
<Data>
<Query>
<References>
<Reference Source="TZ_Products_Version"/>
</References>
<Results>
<Property Source="TZ_Products_Version" Name="ID"/>
<Property Source="TZ_Products_Version" Name="Prod"/>
</Results>
</Query>
<WhereCondition>[ID]=[prmTZProductID]</WhereCondition>
</Data>
<Statements>
<Action Name="SetReturnVar">
<Argument Name="Name">retProductName</Argument>
<Argument Name="Value">[Prod]</Argument>
</Action>
</Statements>
</LookUpRecord>
</Statements>
</DataMacro>
</DataMacros>