Form records

[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

 

[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).

 

[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

 

[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?

 

[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

 

[Christina]

No, the suggestion about the data entry rpoperties did not help.


Thanks

 

[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?