473,325 Members | 2,480 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

No records showing when on form

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
1 1429
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

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

Similar topics

2
by: maddman | last post by:
I have an odd problem with my database, and was hoping someone could point me at the problem. We have an access database that is used by several people to input data. Users have reported some...
13
by: Jan | last post by:
Hi I have a database that I use to keep track of the sales promotions that we send to companies. I normally send a mailing based on a subset of the companies in the database (found using the...
3
by: vanvee | last post by:
Hi I have an application for my company's HR department where we store resumes for candidates we receive. I have an application that uses VB.Net and ADO.Net and data bindings (through code) to...
2
by: Zeljko | last post by:
I'm creating Address book. Header of the main form (frmAddress) contains combo box (cboFilter) to filter records by Occupation on main Form(Ocupation1). That's working. Combo box also have "Show...
10
by: 60325 | last post by:
This is the page where I collect the data in drop-down boxes with values of 1-10 and send it to a submitted page to do calculations. Example: Employee1 TeamScore(1-10) Employee2 ...
1
by: RLau | last post by:
Hi All, I have created a form and subform ( Assignee Outstanding Form ) to display records and related notes in a Helpdesk database table by the assignees respectively. Now, instead of clicking...
11
AccessIdiot
by: AccessIdiot | last post by:
This is odd. I have a form that is related to a table that has 6 or 7 entries in it. When I launch the form it automatically goes to a new record. But it is showing 1 of 1 and I can't go to first or...
0
by: KrazyKoder | last post by:
Hello, I have MS Access form that basically allows the user to configure an update statement to a single table via the gui. A requirement is to show the count of records that will be updated...
2
by: jmprescott | last post by:
I'm having an odd issue and have no idea what could be causing it. I am running a process that will take 25 records from a table and put them into an assignment table. When they records are in the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.