Scripting Problem

[MEG]

I have stumbled across a problem.

I need to "lock" the records if they are marked complete. I created 2 separate layouts (1 viewing (Lock), 1 editing(Entering)). Here is my script:

Enter Find Mode (Pause)

Go to Field (Substrate Number)

Perform Find

If (Completed = "X")

Go to Layout(Lock)

If (IsEmpty(Completed)

Go to Layout (Entering)

End If

End If

"Completed" is the field that the user checks with an "X" if the record is completed with it's run. If there is no "X" in the box I need the record to go back to the Entering layout because they will need to add to this record.

I have this script attached to the "find" button on the layout. It is finding the appropriate set of records but if the complete is not marked it is leaving the record in the Lock layout and not kicking it into the Entering layout.

[markpro]

You may want to create your own navigation buttons and hide the status area. Assign a simular if statement to the previous/next button routines to control the layout as you go to each record in the found set.

[BobWeaver]

Move the first "End If" up two lines as shown here:

Enter Find Mode (Pause)

Go to Field (Substrate Number)

Perform Find

If (Completed = "X")

Go to Layout(Lock)

End If

If (IsEmpty(Completed)

Go to Layout (Entering)

End If

Better yet:

Enter Find Mode (Pause)

Go to Field (Substrate Number)

Perform Find

If (Completed = "X")

Go to Layout(Lock)

Else

Go to Layout (Entering)

End If

[MEG]

Thank you for your reply on the problem script. I entered the script that you suggested and it continues to pick the correct found set, but for example, I have 5 records in a found set and 4 are completed and 1 is not. It shows all 5 records in the "lock" layout, instead of 4 in the "lock" layout and 1 in the "enter" layout. It seems that the layout is "set" by what condition(completed/uncompleted) the first record is in the found set.

Thank You

[markpro]

Finding the records and going to the layout as the previous script suggested is good for the first record in the found set, but as I was suggesting before you still need to control navigation through the found set. Best method I have found is to hide and lock the status area and create your own navigation buttons for Go to Previous, Go to Next, Go to First, and Go to Last. Example below.

Go to Record Next

If (Completed = "X")

Go to Layout(Lock)

Else

Go to Layout (Entering)

End If