New entries not appearing in drop down list

[david.paton]

I am now trying assign Case managers to children and the extra case managers I entered are not appearing in my dropdown list in frmChild, what do I need to do to get them to appear?

 

[arnelgp]

On the after update event of the form:

Private sub form_afterupdate()
' ckk if frmchild is open
If syscmd(acSysCmdGetObjectState, acForm, "frmChild") <> 0 then
Forms!frmChild.Recalc
' or
' forms!frmChild.comboname.requery
End if
End sub

 

[missinglinq]

Wouldn't a simple

Private Sub ComboName_GotFocus()
 Me.ComboName.Requery
End Sub

work?

Linq ;0)>

 

[david.paton]

I tried that and it wouldn't work. What did I do wrong?

 

[david.paton]

i also tried requery on the got focus event but that wouldn't work either. I thought something that simple would work but there must be some underlying issue that is stopping it working.

 

[david.paton]

I think it is because I have added in the query builder, a count of CMChildCMID, to get the case load but I think that is only showing entries that have those case managers that appear in that joining table. Can I still get a count of the case load, but also have all the case managers appear?

 

[david.paton]

I have an idea, how do I add a text box or something similar next to a drop down list that shows all the case managers, that has a count of CMChildCMID from the table tblCMChild?