Pop-up from Datasheet form

[Tablerone]

Would someone mind please having a quick look at the Access 2010 Assets web template, and telling me how they set up the red hyperlinked ID column in form Main that then brings up form AssetDetails?



I really like this, and want to be able to use it in other databases, including desktop (rather than web) ones. I suppose I just look in the properties for this column?

[Tablerone]

<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<UserInterfaceMacros xmlns="http://schemas.microsoft.com/office/...InterfaceMacro For="txtID" Event="OnClick"><Statements><Action Name="OnError"><Argument Name="Goto">Macro Name</Argument><Argument Name="MacroName">ErrorHandler</Argument></Action><ConditionalBlock><If><Condition>[Form].[Dirty]</Condition><Statements><Action Name="SaveRecord"/></Statements></If></ConditionalBlock><ConditionalBlock><If><Condition> IsNull([ID])</Condition><Statements><Comment>Open the form to a new record if the current ID is Null</Comment><Action Name="OpenForm"><Argument Name="FormName">AssetDetails</Argument><Argument Name="DataMode">Add</Argument><Argument Name="WindowMode">Dialog</Argument></Action><Action Name="Requery"/></Statements></If><Else><Statements><Comment>Use a TempVar to pass a filter to the OpenForm action</Comment><Action Name="SetTempVar"><Argument Name="Name">AssetDetails_ID</Argument><Argument Name="Expression">[ID]</Argument></Action><Action Name="OpenForm"><Argument Name="FormName">AssetDetails</Argument><Argument Name="WhereCondition">[ID]=[TempVars]![AssetDetails_ID]</Argument><Argument Name="DataMode">Edit</Argument><Argument Name="WindowMode">Dialog</Argument></Action><Action Name="RemoveTempVar"><Argument Name="Name">AssetDetails_ID</Argument></Action><Action Name="RefreshRecord"/></Statements></Else></ConditionalBlock></Statements><Sub Name="ErrorHandler"><Statements><Action Name="MessageBox"><Argument Name="Message">=[MacroError].[Description]</Argument></Action></Statements></Sub></UserInterfaceMacro></UserInterfaceMacros>

Well I just learnt from a video tutorial that you can now easily copy and paste code into a forum (as XML), so here is what appears to be the relevant code. I don't understand it perfectly, and certainly less in this format.

[Tablerone]

OK, looking at this in Access 2010 (where the presentation is much clearer), I'm beginning to understand this.

But what about "Data Mode" set to Edit or Add. Is "Data Mode" a widely used parameter or would they have had to have defined this as part of creating form AssetDetails?

[Tablerone]

Really hope someone else can chime in and help me out here. Could this code be used to create this functionality in Access 2007?

[Tablerone]

Deleted: I posted this particular reply in the wrong one of my two related threads.