Hey all,

Hope you can help. I have a database with one table with 5 fields:

Table = TimeOffRequest
field 1 = Record No
field 2 = Department
field 3 = Employee Name
field 4 = Date of Request
field 5 = Requested Date

I'm running a parameter query based on the departments (qryDept) which prompts "Enter Parameter Value". I enter the information and it works but I am trying to get it to pull up a custom form (frmDept) with a combo box (cboDept) and cannot get it to pull up the form at all. in the criteria field of the department query I have the following statement that I created using the builder (no typos):

[Forms]![frmDept]![cboDept]

I've been working on resolving this issue for two weeks and have tried everything I have found on this and every forum i have come across. I even started a new database and followed the instructions on the following site:

http://www.fontstuff.com/access/acctut08.htm

I also tried:
http://support.microsoft.com/kb/303134

I'm not sure what going on but now I'm starting to lose sleep over this..
Any help is appreciated.

Sorry, forgot to mention the "[Forms]![frmDept]![cboDept]" shows up in the Enter Parameter Value form...

is cboDept the only thing in the combo box or do you have multiple columns in it? if you do you need to specify the correct column number..

[Forms]![frmDept]![cboDept].column(n)

where n as the first column would be 0