>If you want to call a Form whose purpsoe is solely to give you a larger space to see what is in your notes (Mem field) Edit Box, and you call it like this: DO FORM frmNotes WITH "TableName"
>
>and you go into the form called frmNotes into the INIT procedure, how would you code a reference of the table and the Memo field you want to view in the EditBox?
>
>I did the following, but it isn't working: (The .Notes references the "Notes" field in the table.)
>If the table and the field were referenced as: Hardware.Notes, then how would you reference this generically in the below code?
>
>LPARAMETERS tcTableName
>
>WITH This
> .edtNotes.Value = (tcTableName) + ".Notes"
>ENDWITH
Assuming this table is opened under the same alias as its name, the code will be
LPARAMETERS tcTableName
if used(tcTableName)
>WITH This
> .edtNotes.Value = evaluate(m.tcTableName + ".Notes")
>ENDWITH
endif
You may also add a check for Notes field existence.
If it's not broken, fix it until it is.
My Blog