help with subforms and combo boxes please!!

[Evert]

Hello all,

I need help with the subform I've created and placed in to a main form.
the subform in question contains 2 combo boxes. these cbo's are related to
each other in that when selecting an item from the first cbo the other cbo
only gives the itmes related to the selected item.
The combo boxes work fine as a standalone form. my problems is that when I
place the information as a subform it takes me to a "enter parameter value"
pop up (I have placed the information in a tabbed subform).
the criteria that I have used in the query for the combo boxes when in stand
alone form is
[Forms]![frmSOP1]![SOPDepartmentID]

I have tried most of the combination to try to get the combo boxes to work
in subform but I'm getting nowhere. Even though it works fine with the
changes that I
make it still gives me the pop up box asking for the parameter value.

The main form name is frmPersonnelMain
the query that I use to "tie" the combo boxes is

SELECT tblDepartment.[Department ID], tblSOP1.[SOP Name]
FROM tblDepartment INNER JOIN tblSOP1 ON tblDepartment.[Department ID] =
tblSOP1.[Department ID]
WHERE (((tblDepartment.[Department ID])=[Forms]![frmSOP1]![SOPDepartmentID]));


I realy need some one to walk me thru the steps. please! so that I can get
this done and move on to bigger and better things.

Thank you all very much...

Evert

 

[Dennis]

An Enter Parameter Value" box only opens if you've misspelled a field name
somewhere. If you're assuming that a field named (for example) "MyField" is
bound to your table/form, but you've referenced it as "MyFiled" (misspelled),
Access assumes that YOU will be supplying that value, and will prompt you for
it. Check your spellings and bindings.

 

[Evert]

Thanks for your response Dennis.

I've double check my spelling and I still get the same "enter parameter
value" msg. I only get this messgae when I introduce the form as a subform.
As as stand alone it works perfectly. (no msg)

An Enter Parameter Value" box only opens if you've misspelled a field name
somewhere. If you're assuming that a field named (for example) "MyField" is
bound to your table/form, but you've referenced it as "MyFiled" (misspelled),
Access assumes that YOU will be supplying that value, and will prompt you for
it. Check your spellings and bindings.

Hello all,

I need help with the subform I've created and placed in to a main form.
the subform in question contains 2 combo boxes. these cbo's are related to
each other in that when selecting an item from the first cbo the other cbo
only gives the itmes related to the selected item.
The combo boxes work fine as a standalone form. my problems is that when I
place the information as a subform it takes me to a "enter parameter value"
pop up (I have placed the information in a tabbed subform).
the criteria that I have used in the query for the combo boxes when in stand
alone form is
[Forms]![frmSOP1]![SOPDepartmentID]

I have tried most of the combination to try to get the combo boxes to work
in subform but I'm getting nowhere. Even though it works fine with the
changes that I
make it still gives me the pop up box asking for the parameter value.

The main form name is frmPersonnelMain
the query that I use to "tie" the combo boxes is

SELECT tblDepartment.[Department ID], tblSOP1.[SOP Name]
FROM tblDepartment INNER JOIN tblSOP1 ON tblDepartment.[Department ID] =
tblSOP1.[Department ID]
WHERE (((tblDepartment.[Department ID])=[Forms]![frmSOP1]![SOPDepartmentID]));


I realy need some one to walk me thru the steps. please! so that I can get
this done and move on to bigger and better things.

Thank you all very much...

Evert

 

[JB63]

Did you tie the master and child feilds of your subform with the master form
this is what helped me get the two forms in sink with some other tweaking.

Thanks for your response Dennis.

I've double check my spelling and I still get the same "enter parameter
value" msg. I only get this messgae when I introduce the form as a subform.
As as stand alone it works perfectly. (no msg)

An Enter Parameter Value" box only opens if you've misspelled a field name
somewhere. If you're assuming that a field named (for example) "MyField" is
bound to your table/form, but you've referenced it as "MyFiled" (misspelled),
Access assumes that YOU will be supplying that value, and will prompt you for
it. Check your spellings and bindings.

Hello all,

I need help with the subform I've created and placed in to a main form.
the subform in question contains 2 combo boxes. these cbo's are related to
each other in that when selecting an item from the first cbo the other cbo
only gives the itmes related to the selected item.
The combo boxes work fine as a standalone form. my problems is that when I
place the information as a subform it takes me to a "enter parameter value"
pop up (I have placed the information in a tabbed subform).
the criteria that I have used in the query for the combo boxes when in stand
alone form is
[Forms]![frmSOP1]![SOPDepartmentID]

I have tried most of the combination to try to get the combo boxes to work
in subform but I'm getting nowhere. Even though it works fine with the
changes that I
make it still gives me the pop up box asking for the parameter value.

The main form name is frmPersonnelMain
the query that I use to "tie" the combo boxes is

SELECT tblDepartment.[Department ID], tblSOP1.[SOP Name]
FROM tblDepartment INNER JOIN tblSOP1 ON tblDepartment.[Department ID] =
tblSOP1.[Department ID]
WHERE (((tblDepartment.[Department ID])=[Forms]![frmSOP1]![SOPDepartmentID]));


I realy need some one to walk me thru the steps. please! so that I can get
this done and move on to bigger and better things.

Thank you all very much...

Evert

 

[Evert]

Thanks JB63

Yes I did. There are more field besides the cbo's. and I have no problems
with them it is only with the cbo's taht don't behave as I want them to. As
a matter of fact the sub form is tied by a unique identifier (AssociateID) to
the master form. (frmpersonnelMain)

Did you tie the master and child feilds of your subform with the master form
this is what helped me get the two forms in sink with some other tweaking.

Thanks for your response Dennis.

I've double check my spelling and I still get the same "enter parameter
value" msg. I only get this messgae when I introduce the form as a subform.
As as stand alone it works perfectly. (no msg)

An Enter Parameter Value" box only opens if you've misspelled a field name
somewhere. If you're assuming that a field named (for example) "MyField" is
bound to your table/form, but you've referenced it as "MyFiled" (misspelled),
Access assumes that YOU will be supplying that value, and will prompt you for
it. Check your spellings and bindings.

:

Hello all,

I need help with the subform I've created and placed in to a main form.
the subform in question contains 2 combo boxes. these cbo's are related to
each other in that when selecting an item from the first cbo the other cbo
only gives the itmes related to the selected item.
The combo boxes work fine as a standalone form. my problems is that when I
place the information as a subform it takes me to a "enter parameter value"
pop up (I have placed the information in a tabbed subform).
the criteria that I have used in the query for the combo boxes when in stand
alone form is
[Forms]![frmSOP1]![SOPDepartmentID]

I have tried most of the combination to try to get the combo boxes to work
in subform but I'm getting nowhere. Even though it works fine with the
changes that I
make it still gives me the pop up box asking for the parameter value.

The main form name is frmPersonnelMain
the query that I use to "tie" the combo boxes is

SELECT tblDepartment.[Department ID], tblSOP1.[SOP Name]
FROM tblDepartment INNER JOIN tblSOP1 ON tblDepartment.[Department ID] =
tblSOP1.[Department ID]
WHERE (((tblDepartment.[Department ID])=[Forms]![frmSOP1]![SOPDepartmentID]));


I realy need some one to walk me thru the steps. please! so that I can get
this done and move on to bigger and better things.

Thank you all very much...

Evert