Access Form Combo Box

[ZandyRox]

I have a query (qryQuickSheet) that has the following command: [Forms]![frmProjectSearch]![proj_name] for the field "proj_name"



I have frmProject Search that has proj_name as a combo box. I have the combo box to open frmQuickSheet (basically the data for qryQuicksheet) after update.

When I update the combo box, I get a enter parameter value dialogue box. The combo box should prevent this from happening.

How do I make the dialogue box disappear?

Please advise.


Zandy Rox

[thebigthing313]

Are you saying you're using a combobox to open a SUBform frmQuicksheet, who's parent is frmProjectSearch?

[ItsMe]

Can you post the SQL for your qryQuickSheet? What is the Rowsource for your combo and what is the Bound Column property?

[John_G]

What parameter is the dialog box asking for?

Try renaming the combo box from 'proj_name' to something else - it's possible that Access is getting confused with a query field and the combo box with the same name.

What is the code in the combo box after update event?

[ZandyRox]

I'm using the combobox to open frmQuickSheet which is based on query qryQuickSheet.

frmProjectSearch is a form from scratch. The combo box pulls from a list of project names.

[ZandyRox]

SELECT tbl_projects.proj_num, tbl_projects.proj_name, tbl_projects.proj_srvc_aact, tbl_projects.proj_jurisdiction, tbl_milestones.stage, tbl_milestones.status, tbl_projects.proj_category
FROM tbl_projects LEFT JOIN tbl_milestones ON tbl_projects.ID = tbl_milestones.proj_id
WHERE (((tbl_projects.proj_name)=[Forms]![frmProjectSearch]![proj_name]));

[ZandyRox]

Its an embedded Macro to openform frmQuickSheet

[ItsMe]

Its an embedded Macro to openform frmQuickSheet

Is the macro closing frmProjectSearch?

[ZandyRox]

no. the macro opens frmquicksheet

[ItsMe]

The combo properties may shed some light on the issue.

[ZandyRox]

Can you open the link below to view?
Click here to view

[ZandyRox]

Just following up. I sent the database in the previous posting. Any ideas?

[ItsMe]

What is the Rowsource for your combo and what is the Bound Column property?

[ZandyRox]

Row Source: SELECT [tbl_projects].[ID], [tbl_projects].[proj_name] FROM tbl_projects ORDER BY [proj_name];

Bound Column: 2

[ItsMe]

I believe the solution is in post #4. You need to figure out what the names of your controls are and adjust your SQL in the query to look at the correct control name.

Furthermore, the value of your combo may be Null if the Macro is executing before the Value property is getting updated. So also make sure that your are using After Update as your event handler.