Referring problem

[Soegstad]

Hi guys.
I searched for this (probably easily solved) problem but cannot seem to find a solution.
What I want to do is to send a value from a table (tbl1) to a control (ctr1) in a form (frm1) in an after update event.
This is what I have so far:

Private Sub Command_AfterUpdate()
Me![Ctr1] = Table!Table1!Value1
End Sub

Thanks

 

[Soegstad]

Solved the problem by using DLookup.

Private Sub Command_AfterUpdate()
Me![Ctr1] = DLookup("[Value1]", "tblTable1")
End Sub

Thanks anyways

 

[Rich]

Why not use a combo box?