How might I go about setting up a form to auto-fill any information that was entered in the last record, based on a lookup field? I dont want to change the original record, I want it to just populate the field that have been entered already for a new entry. This way the table will track updates and changes.
Hope this makes sense :banghead:
Hope this makes sense :banghead: