Which employee has the record?

[Banaticus]

In the startup screen, it would check for the employee name (Windows Uer Name) and adds it to a table if it's not there. The table is the basis for a combo box which can be set to list which employee has a given person. How do I use an Insert statement? I'd like to do somehthing like the following

Me.EmployeeNameBox = StrConv(GetUserName.fOSUserName, vbProperCase)

If DLookUp(Employees, EmployeeTbl, Me.EmployeeNameBox.Value) Then
	'Blah
Else
	INSERT INTO EmployeeTbl (Employees)
	VALUES (Me.EmployeeNameBox.Value)
End If

 

[Robert88]

Hi Banaticus,

try this connection http://www.access-programmers.co.uk/forums/showthread.php?t=101435

I hope it helps.

Robert88