Access Form Combo Box

[ZandyRox]

I re-read post #4. Why would I change 'proj_name'? Wouldn't I need them to be the same so they would link up?



Also, I tried renaming it 'combo11' and a dialogue box still comes up.

I double checked that I was using After Update.

What about deleting the combo box and bring it back?

[ItsMe]

Try naming the combo combo11 and

your SQL for the query would look more like
WHERE (((tbl_projects.proj_name)=[Forms]![frmProjectSearch]![combo11]));

[ZandyRox]

DONE.

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]![Combo11]));

AND DONE.

In the property sheet, under Other, there is a field for Name. I put in Combo11.

[ZandyRox]

Could there be something wrong with this statement: [Forms]![frmProjectSearch]![Combo11]

[ssanfu]

In my testing, (using 32 bit A2010) it appears that the VBA project is corrupt or is going corrupt.
I can open the database, open the search form, select a project and get the parameter dialog box.
Then do a compact and repair.
Close the database after clicking on enough buttons.
Close the database.
Open the database.

At some point, the quick form pops up - no errors - the form is populated. Seems to work with out errors.

You might want to create a new blank database and import the objects from the old dB...

Also, you have the PK of every table names "ID". While this is not technically wrong, it is confusing. It would be better to use names like
"ContactID", "PriorityID" or "MilestonesID"..... Actually, I would use "ContactPK" or "Contact_PK". And in the related table I would use "Contact_FK" or "ContactFK", etc..

You have used reserved words as field names - not a good idea. Two examples that jumped out at me are "Date" and "Type". Besides being reserved words, they are not very descriptive. "Type" of what??? "Date" of what???

My 2 cents......

[ZandyRox]

My apologies for the bugs. I inherited this database (it was built before my time)...I gotta deal with one issue at a time.

I will probably just create a new database and import.

Thanks!

[ItsMe]

Steve!! Where the heck have you been? Glad to see you!

[ssanfu]

Been slammed at work and family issues. Been so long I forgot my password!!!