I created a form in datasheet view to show as a list, in the sheet, the following are
Form 1 name=fPDI (Form)
field1 = tpdiid - this is a unique no.
Datasheet List
field1 = tpdiid - this is also part of the list.
now i made a macro button in the datasheet list, that when you click field1 in the datasheet list, it will open the Form 1 in the unique data no. the code i entered is:
docmd.openform "fPDI",,,"[fPDI.tpdiid]" & [fPDI.tpdiid]
This is where the problem appears, when i click the tpdiid field in the datasheet view, this error appears:
Run-Time error '2465'
Microsoft Office Access can't find the field "|" referred to in your expression
I deleted the field1 and replaced it again, still the same error.
I copied the same command from a another database where it works, replaced the right fields, but still the same error.
I recreated the form from scratch without changing anything, just copy and drag the fields to a blank form and still the problem persist.
can you please help me on this and explain to me.
Thank you.
Trident