By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,106 Members | 2,474 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,106 IT Pros & Developers. It's quick & easy.

No records showing when on form

P: 6
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.
Sep 27 '06 #1
Share this Question
Share on Google+
1 Reply


P: 6
Can anyone help???


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.
Sep 28 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.