User Name Combo Box

cross5900

Blarg!
Local time
Yesterday, 22:06
Joined
Mar 24, 2006
Messages
92
I have two tables.

1) tbl_Information - which carries all of my information that I will be primarily messing with.

2) Users - this is used during the first login of the database and basically registers them and their computer to the database.

What I am wanting to do in my form is have a combo box that will display all the names that are registered with the database.

What I am trying to do is create the ability to assign work to that specific person. Please ask questions if none of this makes sense and I will provide my query SQL that I have so far.

Code:
SELECT Tbl_Information.*
FROM Tbl_Information LEFT JOIN Users ON Tbl_Information.UserName = Users.UserName
WHERE (((nz([fllwDate],Date()))<=Date()) AND ((Tbl_Information.Cleared)=False))
ORDER BY nz([fllwDate],Date());

Thanks in advance.
 

Users who are viewing this thread

Back
Top Bottom