Access - Macro performing differently on different forms/reports
I have a macro that makes a displayed record click-able in turn opening the record in a new window for editing.
It works as expected when displaying a report, but when called from a form the macro always pulls record 1 despite the item clicked. All data is pulled from the same table using the same macro so in theory should just work.
If IsNull([AssetID]) Then
If Not IsNull([AssetID]) Then
Where Condition = = "[AssetID]"
Window Mode Dialog
Go to Next
Cant for the life of me see why!
Anyone else spot the error?