Searchforrecord Subform Combo Box

[birth19]

Hi All,

Basically, I had a form named "previous week".

It had three cascading combo boxes

Combo9 - Week Number


Combo11 - Project Manager
Combo13 - Project Name

Now I have sorted it so the subform is included on the query criteria for each combo box.

I normally use this code with an afterupdate searchforrecord macro where condition.

="[Project Name] = " & "'" & [Screen].[ActiveControl] & "'"

This normal pulls up all the information I need but I understand it is because the above code needs to reference the sub form in some way but I cannot think of it.

Can someone help me please??

[June7]

Want to provide db for analysis? Follow instructions at bottom of my post.

Project Manager and Project Name are not in the main form RecordSource, they are in subform? Subform object is in Datasheet view?

I always give subform container controls a name different from the object they hold, like ctrDetails.

I don't use macros, only VBA.

Maybe:
="Forms!formname!ctrDetails![Project Name] = " & "'" & [Screen].[ActiveControl] & "'"

[birth19]

Project Manager and Project Name are in the recordsource and in the subform.

Subform is in a form view.

[June7]

I don't understand what you are trying to do. Why would both fields be in both main and sub forms? Probably should provide db for analysis.

[birth19]

Basically the form is a Weekly entry form, where they report on the project status for the week.

I have put in a subform that will give the user the option of looking at previous weekly entrys so they can get historic data.

I have the main form as data input and I have the sub form as locked fields apart from the combo boxes.

='[Forms]![Weekly Entry]![Project Name]' = " & "'" & [Screen].[ActiveControl] & "'"

This is basically what I want to do but can't.

Im unable to attach due to whopping size.

[June7]

Having main and sub forms with the same data source is unusual and problematic. Might be workable but just not too familiar with this setup. A split form might suit your situation.

If my suggested syntax still doesn't resolve issue, I will have to examine and test db. Don't care about real data. You could make a copy without data (a few dummy records could be helpful) and provide it for analysis.