Startup different form for different users

[Krullms]

I was just wondering if there is a way to open a form for the Read user and a different form for the Fulldata user.
This way the read only user can't see the options or goto the options that the fulldata user has.

Thanks,
Mike

 

[jrbarnett]

You can only have one startup form defined. A way around this would have to have a dummy form that picks up the current username and opens the appropriate form depending upon who the current user is.

John

 

[TheAceMan1]

How are ya Krullms . . . . .

Consider an independent table with fields:
[purple]UsrName
UsrType (Read/Full/Other?)[/purple]

You could us an [blue]AutoExec[/blue] macro to call a function that looks up the [blue]CurrentUser[/blue] and opens the approriate form.

See Ya! . . . . . .

 

[FancyPrairie]

My AutoExec macro launches a startup function. One of the things this function does is it gets the current user name, opens a table to find that user, and then reads the name of the form assigned to that user. I then open that form found in the record.

Pretty much similar to what Aceman1 was referring to.

 

[Krullms]

Thanks for the tips, I ended up copying my switchboard form and table and editing one to only have the buttons that the read only user can use. I then just have a splash screen which looks at user then loads the right switchboard.

Thankyou
Mike