With username u can find out the department. In table where departments are stored you add a field Swithboard where you put in the formname per department. On the first...

I normally use two id colomns, guid and int

with select NewId() i place a new guid in a varaible and use that one on the insert statement.

than to get the int...

or use docmd.runsql in vba

I find it better to use a sql back-end...

Maybe you should try using VBA.

        Set cn = CurrentProject.Connection

        Dim rst As New ADODB.Recordset

        Dim sqlStr, PrevPackSlipID As String

        Dim i As...

Solution:

declare @PackSlipID float, @ProductName varchar(50), @Num integer, @PreviosPackSlipID float

declare rst cursor for

      select PackSlipID, ProductName

      from WorkTable

   order by PackSlipID, ProductName

Set @PreviosPackSlipID = 0

Set @Num = 1

  open rst

    fetch next...

What Dick said and with this code in a module you can obtain the userinfo without prompting them each time they open the program (users get tired of that very quikly;-)...