I want to create a Continuous Form which shows outstanding invoices with fields: InvoiceNo, InvoiceAmt & SettleAmt.
The InvoiceNo & InvoiceAmt is locked, user only enter the SettleAmt.
I set the Record Source = SELECT InvoiceNo, InvoiceAmt, 0 AS SettleAmt FROM Invoice.
When I view the form, I cannot enter values in SettleAmt.
It shows that SettleAmt is based on expression and cannot edit.
What is the proper setting or procedure to implement it?
Thanks.