Combo Box update Subform

[rhett7660]

Combo Box Filter Subform?

Hello..

I have looked and searched but still can't find what I am looking to do.

I have a form with a subform: frmMainData and frmSubComponent. Each form is based off a different query: frmMainData = qryLocationPhase and frmSubComponent = qryComponent

I have a one to many relationship setup for the tables the queries are based off. IE one location many components.

On the form I have a two drop down boxes. cboUOA and cboPhase.

What I would like to do is have the cboUOA requery the subform and the cboPhase so that the location is entered and everything assigned to that location shows up in the subform. I have tried a different requeres and I have not been able to get it work.

I have attached my database.

 

[rhett7660]

Hmm.. I took out the cboPhase to try and make it a little easier. I cannot get this to work? Anybody have any ideas?

 

[rhett7660]

Can anyone take a look at this? I still can't get it to work.

 

[MStef]

Hello DSB!
Here it is.
You have to learn much more, your MDB is a scrap.

 

[rhett7660]

Hello DSB!
Here it is.
You have to learn much more, your MDB is a scrap.

Thank you very much...... Trust me I know I have a lot to learn. Hence the reason I am here. Do you think I should start over on this one?

Thanks
R~

PS, who is DSB?

 

[MStef]

DSB is an author of "DigitalSignage.mdb" (I think it is you).
Open MDB window, click on FILE, DATABASE PROPERTIES, SUMMARY, look at "Author".

 

[rhett7660]

Ha.......... Didn't even know I did that... It isn't me, it actually going to that unit. That is funny....

MStef..

Thanks again for your help.
R~