I modified this from an earlier message, since I resolved the problem of the extra digit in the LE name. Current issure:

One application, two forms named Cost and Orders. LEs on Cost include: Rec_No; Cost2; Qty0 and Description.
LEs on Orders include: Rec_No0 and Total_Cost. The form, Cost, is displayed as a spreadsheet on a tab of Orders. Programming:

If Description = "Labor" then begin

Qty0 = "1"

(I know the following should be conditional, but I'm just trying to get it to work)
XLookup(@FN,Rec_No,"Orders!Rec_No0","Orders!Total_Cost",Cost2)    --(I tried this without the second Orders! before Total_Cost)

If @error then @Msgbox("Sorry","","")

Goto Qty0

end

I have verified that the fields are bound to the same type of elements (numbers, money). I through the @error in just to check what was going on. Oddly, the above statement, or something very similar, worked once. Can't get it to function now. Any help??

I have been trying this in runtime. I also have tried it without the duplicate form name. I'm going through all the other code trying to see if something else is causing the glitch. Thanks for verifying that part of the code at least.

Quote:

I'm sorry, now I see that you left a note already stating that, in your first post. I don't know how I overlooked it.

Quote:

This may be because the subrecords are not saved until you save the parent record, or specifically save the subrecord. You would have to save the subrecord before the xlookup will work correctly.

Can you use @FormFieldValue rather than xlookup? It seems to work even if the subrecord has not yet been saved to disk.

Thank you Carl!!! ummm, why didn't you tell me this at 5:00 this morning when I started banging my head against the wall with this "thing"???  Nice to learn another new trick.  8)