Discussion Locked

Lookup works in query but not in form

0 helpful
0 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
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.

0 replies

No replies were posted before this discussion closed.

This discussion is closed to new replies.