Combo Box Not Working (1 Viewer)

[aftab1965]

Dear friends !
I need your help. ( db Attached)
Im new to MS Access, I have 3 forms having combo boxes, each form is working perfectly. I created a Navigation Form (Main Form) , by attaching these (sub) forms to navigation Form, Combo Boxes on all forms(Sub) are not working.

Thanks

 

[pbaldy]

The syntax to refer to it changes when it's a subform:

Forms: Refer to Form and Subform properties and controls

 

[missinglinq]

Which is a good argument for not using Navigation Forms...most experienced developers don't!

Much better to 'roll your own' nav form'...where each Form is an independent Form to be opened!

Linq ;0)>

 

[aftab1965]

The syntax to refer to it changes when it's a subform:

Forms: Refer to Form and Subform properties and controls

Dear friend, thanks for your reply.
Can you please share me screen shot or a new db after removing anomaly

 

[pbaldy]

I could, but I'd rather you tried. The syntax for your situation:

Forms!Mainform!Subform1.Form!ControlName

replacing the items in red as appropriate.

 

[June7]

Have to reference subform container name. Nature of Navigation Form is only one subform at a time is available. Clicking tabs unload and load forms as Navigation Target. This means all 3 SQL will refer to the same container name. Access assigns NavigationSubform as container name and you did not change it.

 

[aftab1965]

I could, but I'd rather you tried. The syntax for your situation:

Forms!Mainform!Subform1.Form!ControlName

replacing the items in red as appropriate.

I tried but it didn't work. Plz help me by snapshot or forwarding db.
Regards

 

[aftab1965]

Have to reference subform container name. Nature of Navigation Form is only one subform at a time is available. Clicking tabs unload and load forms as Navigation Target. This means all 3 SQL will refer to the same container name. Access assigns NavigationSubform as container name and you did not change it.

Thanks for guidance. I need your help as I'm new to Access. Can you please share a snapshot or a new db.

 

[June7]

SELECT EQUIPMENT.Local_ID, EQUIPMENT.Notes, EQUIPMENT.Location, EQUIPMENT.Noun, EQUIPMENT.Model, EQUIPMENT.Make, EQUIPMENT.SNo, EQUIPMENT.Status
FROM EQUIPMENT
WHERE (((EQUIPMENT.Local_ID)=[Forms]![1Navigation Form]![NavigationSubform].[Form]![CboLocal]));

 

[aftab1965]

SELECT EQUIPMENT.Local_ID, EQUIPMENT.Notes, EQUIPMENT.Location, EQUIPMENT.Noun, EQUIPMENT.Model, EQUIPMENT.Make, EQUIPMENT.SNo, EQUIPMENT.Status
FROM EQUIPMENT
WHERE (((EQUIPMENT.Local_ID)=[Forms]![1Navigation Form]![NavigationSubform].[Form]![CboLocal]));

Thanks sir,
Plz do me on thing clear that this I will write in the "data source row" of my subform on Navigation Form or cbolocalid?

 

[June7]

It's the SQL for qryEqpt.