On retrieve Spec Open event that place the @ClientLocalValue ("CurrentRecord") in one of the element and Load the Retrieve spec. but that creates a problem that when I want to search/update in that particular layout it would not let me fill out retrieve spec form, it would directly go to Mode 1 that is update mode.   

On retrieve Spec open

var vStr as String

RecNumber = @ClientLocalValue ("CurrentRecord")

vStr = @SpecCommand (2, 1, "")
 

I believe, I have to use some conditional statement here to avoid it.  Is there any marker that indicates whether the particular Layout is closed or open? Any suggestions? Thanks.

Thanks Ray. I will have to reset the value of @ClientLocalValue ("CurrentRecord") to "" otherwise it will retain the value of the last opened record. I think On Exit Form event I can reset the value.

Ray, did you have chance to look at the warning message that one receives while opening a form from a form while adding a record?
"The current record has been changed and has not been committed to the database. Are you sure you want to close the record?"

Obviously this message has no value as even if you choose "Yes", the record will remain open and it will display the other form as it is supposed to. I mentioned this in my yesterday's query.

The other thing I have noticed is, when you open the form using @ClientLocalValue ("CurrentRecord") in one of the retrieve spec element, it displayed the expected subject record. However, I expect it to have the resultset having only that particular record, instead the resultset has all the records in the database. Wondering Why? Am I clear?  Thanks Ray for your input and suggestion.