Update field from unrelated query

[liddlem]

Hi
On my 'on load' event of my Navigation form, I get the Logged-In-User-ID and assign that to a hidden label (Label62).

I then have a query (Qry_LoggedInUser) that filters the user info according Label62.caption.

I am writing an 'after update' event on a field called PO_Num, that will look at the query and assign the "Display Name" to the 'Ordered By' Field on my form. But I cant get it to work.
What am I missing?
Do I first need to requery?

My code says

Private Sub PONum_AfterUpdate()
    Me.CreatedBy = Forms![NPYWC]![Label62].Caption 'This works fine cos it come from the label
    Me.Combo77 = [Qry_LoggedInUser]![Display name].Value ' this one is not working.
End Sub

Thanks

 

[liddlem]

Problem Solved.
I figures out a way to do this, but thenrealised that it created other issues for me later. So i have had to abandon this plan anyhow.