Form records


C

Christina

I have two forms. Employee records, and a subform named salary records. The
ID fields are linked ..child field. When I choose an employee in the
employee records form, automatically the salary records form shows a blank
record, with thr corresponding ID. However I cannot see all the records that
have been entered on the Salary records.

Please help. Thanks
 
Ad

Advertisements

J

John W. Vinson

I have two forms. Employee records, and a subform named salary records. The
ID fields are linked ..child field. When I choose an employee in the
employee records form, automatically the salary records form shows a blank
record, with thr corresponding ID. However I cannot see all the records that
have been entered on the Salary records.

Please help. Thanks

My guess is that you have set the Data Entry property of the subform to Yes.
This suppresses the display of existing records. Set it to No and you'll see
them.

If that's not the problem, please post back with the Recordsource of the
mainform and subform (post the SQL view or, if it's a table, the fieldnames).
 
C

Christina

There are two tables that the forms are linked to.
Actually it is the SSN number that is linked.

Hope this info helps. Thanks
SALARY RECORDS
ID Net Pay Social Security Taxes Name Income Tax Hours Worked Overtime
Rate Reg Hours
Reg Hrs Wage Hourly Wage OT OT Wage Daily Wage Gross Hourly Rate Check
Number Beginning Pay Period
Ending Pay Period Number of Weeks Social Security
Number Food Miles Misc Phone Monday Tuesday
Wednesday Thursday Friday Saturday Sunday Days Worked Daily
Rate Advances Diesel
Other Deduction 4 Miscellaneous Remarks



EMPLOYEE RECORDS

Name Social Security Number TaxPayerNo Hourly Wage Status Qualifications
 
J

John W. Vinson

There are two tables that the forms are linked to.
Actually it is the SSN number that is linked.

Hope this info helps. Thanks
SALARY RECORDS
ID Net Pay Social Security Taxes Name Income Tax Hours Worked Overtime
Rate Reg Hours
Reg Hrs Wage Hourly Wage OT OT Wage Daily Wage Gross Hourly Rate Check
Number Beginning Pay Period
Ending Pay Period Number of Weeks Social Security
Number Food Miles Misc Phone Monday Tuesday
Wednesday Thursday Friday Saturday Sunday Days Worked Daily
Rate Advances Diesel
Other Deduction 4 Miscellaneous Remarks



EMPLOYEE RECORDS

Name Social Security Number TaxPayerNo Hourly Wage Status Qualifications

If you have fields named Monday, Tuesday, ... in your salary records table,
your tables are not correctly normalized. Word wrap made a complete hash of
what you posted, so I'm not at all sure what you're trying to convey!

And if you have just these two tables, your structure is certainly incorrect.
For example, the employee's name should exist in the Employee Records table
only, not redundantly in the salary records table; it appears that you have
some calculated fields such as "net pay"???

Did the suggestion about Data Entry help? If you look in the Salary Records
table itself in datasheet view, do you see the records you expect?
 
C

Christina

Sorry...The name appears only in the employee records. I do have some
calculated fields on the form. The records do appear in the table, but would
like to have the ability to go back and view a past record.


THanks
 
Ad

Advertisements

J

John W. Vinson

Sorry...The name appears only in the employee records. I do have some
calculated fields on the form. The records do appear in the table, but would
like to have the ability to go back and view a past record.

A basic Access form, with the "Data Entry" property set to No, has a set of
navigation buttons (a left arrow, a textbox with a record number, a right
arrow, and a right arrow with an asterisk to go to the blank new record).

Does your form not have these? Or if it does can you not use it to navigate?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top