ComboBox based on another Combobox 1

[Blondie96]

I have a form to request usage of a room (type). Required information is Office user is in (i.e. Accounting)
and then 2 POC fields (Submitting & emergency) the lists for the POC fields are limited to those who belong to the Office chosen.

The cboOffice works,

The POC field query is:

SELECT POC.POCID, Title!Title & " " & POC![First Name] & " " & POC![Last Name] AS POC1
FROM Title INNER JOIN POC ON Title.TitleID = POC.Title
WHERE ((([POC]![OfficeID])=[forms]![ScheduleRequest].[OfficeID]));

The same query is used for the EmPoc except it is "as POC2"

When I first enter the form, I selct Office, then hit the dropdown box for SubPOC (it shows an empty list). I have the properties box open. I click on rowsource build button, the query opens, I close the query (with no changes). Then hit the dropdown box for SubPOC & the list is present.

The same things happen when I click on EmPOC.

I'm sure I left something off the form/field. Could someone help me?

Thanks,
Tamra

 

[ZmrAbdulla]

Use a Me.ListBoxName.Requery after entering the item.

________________________________________
Zameer Abdulla
Visit Me
There is only one perfect child in this world. Every mother has it.

 

[Blondie96]

Thanks ZmrAbdulla,

but what do you mean "after entering the item"

where should I put the code?

 

[Blondie96]

Thanks, I got it.