I have a complex database with multiple subforms. In one a lookup is performed on another table to return a description. The query works but when in the form it does not. I have tried coding me.form.requery in the afterupdate function but the record is not saved and all data for the new entry is lost. I am obviously missing something. Any help will be appreciated. I would also like a source or reference book for effective VB coding in access if any one knows of one. Thanks.
