"enter Parameter Value" form instead of custom form trouble

[eddyfuente]

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.


​

 

[eddyfuente]

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

 

[rainman89]

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

where n as the first column would be 0