I've been trying for hours to figure out how to simply add my new values (AccountID & InvoiceID) into my form but auto-populate (non edit) from my BillID table.
I have other auto-fill labels but do not know how to effectively work Access to speak layman terms to it. I actually had a friend create this document but could not reach.
Within my Bill Payment Form, there are auto populated labels (Company Name, First, Last, Bill Amount, etc) that are obtained from "BillID". I have added two extra fields (AccountID and InvoiceID) that I would like to auto fill the information without
options for edit.
How would I be able to do this? Below is a link to my google drive with the Access document (test) to understand the issue. There is a lot of stuff going on, I apologize. Feel free to correct anything out of place. I am trying to go into 2019 more financially
responsible.
https://drive.google.com/file/d/1BPFaCWjP2iv2SEswMe2TgfLf2hLQUrcd/view?usp=sharing
Thanks!
