Frame formula for switching local or server db

Hi

I have a database (db1) that contains a frameset with a frame that shows another database(db2).

When using the servers replica of the db1 it opens the servers db2 in the frame no problems.

Whe using the local replica of the db1 it opens the local db2 in the frame no problems.

Server:=@ServerName;

Path:=“test/test.nsf”;

@If(Server=“”;Path;Server+“!!”+Path)

However I’d like to expand this and have the local db1 to open the server db2 if the current location is “Office” and open the local db2 if the current location is “Home” or “Travel”. This is so it suits laptop users.

Can anyone help with this? I’ve tried the @Command([Openmail]) but designer won’t allow the @Commands.

Subject: Frame formula for switching local or server db

Hi All

I have solved my problem and the solution is below for anyone requiring this in the future.

Server:=@Subset(@MailDbName;1);

Path:=“test/test.nsf”;

@If(Server=“”;Path;Server+“!!”+Path)

Steven