Hello, I have two issues I need help with:
I have a Data Entry form called Frm_Entry (with a corresponding table) with the following fields:
Date Assigned (Date)
Date Processed (Date)
Date Submitted (Date)
MS-Company (Text)
Client (Text)
Reimbursement Amount
Submission Amount
Total Payout (Auto sums)
Paid (Yes/No) that if checked enables the visibility of the "Date Paid" field
Problem #1: When I open my Entry form and enter a record, then try to scroll through previous records all fields remain blank. I went to the corresponding table and all records are there. Why can I see them in the table but not in the form when scrolling using the record arrows?
Problem #2: I have tried to make the MS-Company field a List box feeding from a Table MS-Company which holds a list of companies. I can make it a list box as well as link it to the list table. My problem is how to make it so that whatever someone selects in that list box on the Entry form automatically fills in the corresponding MS-Company field in the Entry table. As I have tried it, it appears ok when selecting a company off the list on the form, but when you go to the table after entering a record on the form, that field is blank for the record I just entered.
Can someone help. I apologize if this is a simple fix. I am still learning.
Thanks in advance.
I have a Data Entry form called Frm_Entry (with a corresponding table) with the following fields:
Date Assigned (Date)
Date Processed (Date)
Date Submitted (Date)
MS-Company (Text)
Client (Text)
Reimbursement Amount
Submission Amount
Total Payout (Auto sums)
Paid (Yes/No) that if checked enables the visibility of the "Date Paid" field
Problem #1: When I open my Entry form and enter a record, then try to scroll through previous records all fields remain blank. I went to the corresponding table and all records are there. Why can I see them in the table but not in the form when scrolling using the record arrows?
Problem #2: I have tried to make the MS-Company field a List box feeding from a Table MS-Company which holds a list of companies. I can make it a list box as well as link it to the list table. My problem is how to make it so that whatever someone selects in that list box on the Entry form automatically fills in the corresponding MS-Company field in the Entry table. As I have tried it, it appears ok when selecting a company off the list on the form, but when you go to the table after entering a record on the form, that field is blank for the record I just entered.
Can someone help. I apologize if this is a simple fix. I am still learning.
Thanks in advance.
Comment