none
Autopopulate Account ID & Invoice ID in Access from Bill ID Table RRS feed

  • Question

  • 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!

    Saturday, December 8, 2018 8:26 PM