I should know how to do this but I'm drawing a blank. I have a field on a form. Its record source is a field in the bound table. I want to populate it and have it drop in the field in the table with a DLookup like:
but I can't figure out where to put that code. I've tried the onopen event of the form and also the beforeupdate event of the form but it doesn't work.
Any help much appreciated.