Wanting to assign "User ID" to variable

ach

Hi There,

I have a form which is basically used to filter data in a lines table.

On launching the form I want the form to display a default value in one of the filter fields equal to the current "User ID".

The problem I have is that no matter where I place this assignment it either doesn't show the value or only does when I click on the field.

In the OnAfterValidate of form I have the following


IF UserFilter = '' THEN
SETRANGE("User ID")
ELSE
SETRANGE("User ID",UserFilter);
CurrForm.UPDATE;

At the beginning of this code I want to add the equivelant of UserFilter := "User ID"; and in doing so have the user ID appear immediately for all to see, what am I overlooking.

Many Thanks

Sbhat

Hi,

Put your code in OnOpenForm() and OnAfterGetRecord() Trigger and it would work.

Regards
SB

fb

UserFilter := USERID;