Help with dropdown box using a default - Happy Saturday!

[Wag2016]

Hi All, Happy Saturday!

I am having trouble with some syntax for a form.

Structure:

Employee Table storing the following fields. Field Names in ()

Username (their Clock ID) Primary
Lookup (their Full Name)
Level (Level - Associate, Manager, Exec, etc)
Manager (Who their manager is - stored as manager's Username)

I have a continuous form that is the user's queue - it holds checklists. Each record has a Manager dropdown because the user needs to assign that manager to review the checklist and once they hit submit the checklist goes to that manager's queue. I have the employee table setup to assign the approving manager to each employee - their default. But, sometimes the checklist needs to go to a different manager. Therefore, I can't automatically assign the manager on the queue. They need to choose.

I have a dropdown for the manager field (cboManager). Here is the sql.

SELECT tbl_Employees.Username, tbl_Employees.Lookup, tbl_Employees.Level FROM tbl_Employees WHERE (((tbl_Employees.Level)="Exec")) ORDER BY tbl_Employees.Lookup;

What I am looking to do is have the control default to the approving manager based on their employee profile, but still dropdown to allow them to choose someone else.

Is this possible? I tried DLookup in the default field and didn't get far.

Thanks so much for the help. If you need additional info please let me know.

Laura

 

[pbaldy]

I would try setting the default value property of the combo in the load event of the form. I assume the user will have logged in somehow, and you can use that in a DLookup() or recordset to get their manager.

 

[Wag2016]

I would try setting the default value property of the combo in the load event of the form. I assume the user will have logged in somehow, and you can use that in a DLookup() or recordset to get their manager.

Hi, thank you - that sounds like a great idea! I will try it.

 

[pbaldy]

No problem, post back if you get stuck.