In my Invoice form, I have several sections which contain parallel columns of elements for entering prices.  The left hand column elements can be filled by a lookup into the Workorder database, or entered manually.  The right hand column is for manual entry only.  I need to restrict the user so that he can only use one column.  That is, if anything is entered in the left hand column, entry into the right hand column is forbidden.

I plan to be experimenting with ReadOnly(), so that if any of one column's elements have a value, the other column becomes read only.  Before I head down that road, I have a question:

Say a user creates an Invoice and puts some figures into the manual right hand column (that is, he does not perform the Workorder lookup).  The left hand column will become Read Only.  He saves the record and goes on a coffee break.

Later he remembers some extra work that was performed on the job, so he updates the Workorder.  Then he goes back into the Invoice record and performs the Lookup.  The programming will retrieve the values from the Workorder and try to jam them into the left hand Read Only elements in the Invoice. 

What would happen?  Would the elements fill or not?  If they do then I'll have values in both the left and right hand columns, which would be a bad thing.  Would the lookup just fail?  Failure wouldn't necessarily be bad, because I could program a message saying "Oops, you gotta delete those other values first".

Thanks in advance for your help.

Ah, of course, thanks.  That will work.  I'm still interested in what would happen though.

So far, I've programmed the left column to turn the right column Read Only when a value is entered in the left.  However, pressing "Enter" still jumps me into the Read Only element.  I can't edit it, but that's where I land.  Will I need to program some "Go To" statements?

Quote:


Thank you.

Quote:


Yep, but I figured that if it would result in the situation you describe, it would be hours of wasted time and effort.  You've saved me all that, and I appreciate it.  I'll fade back into silence now.