ACC97: Time Cards Subform Not Filtered with New Records

• Microsoft Access 97

SYMPTOMS

Novice: Requires knowledge of the user interface on single-user computers.

The information in this article applies to a database that you created by using the Database Wizard and the Time And Billing.mdz template.

Each time that you open the Time Cards form and click the new record navigation button on the form, rather then displaying a new, blank record, the Time Cards Subform displays time card information from another record. This behavior occurs each time that you open the form and add a new record by using the navigation button. The behavior does not occur if you click Data Entry on the Records menu.

NOTE: This behavior also occurs in a Time And Billing database that you upgraded from Microsoft Access 7.0.

RESOLUTION

Edit the Time Card form to add the TimeCardID field. You can set the Visible property of this field to No if you do not want to see it. To do so, follow these steps:

1. Open the Time Cards form in Design view.



2. If the Field list is not already open, on the View menu, click Field List.



3. Drag the TimeCardID field from the Field List to an empty space on the Time Cards form.



4. If the property sheet is not already open, on the View menu, click Properties.



5. Set the Visible property of the TimeCardID text box to No.



6. Save the form and close it.

MORE INFORMATION

Steps to Reproduce Behavior

1. Start Microsoft Access, and click to select the Database Wizard button in the opening dialog box. Click OK.



2. In the New dialog box, click the Databases tab, and then select the Time And Billing.mdz template. Click OK.



3. In the File New Database dialog box, select a folder, type a file name for the new database, and then click Create.



4. Click Next on the first screen of the Database Wizard.



5. On the second screen of the Database Wizard, click to select "Yes, include sample data," and then click Finish.



6. After Microsoft Access creates the database and displays the Main Switchboard form, click Enter/View Time Cards.



7. Note the date and project information in the Time Worked box, and then click the new record navigation button at the bottom of the Time Card form.



8. Select an employee name in the Employee box on the form, and note that the Time Worked box displays the same information that you noted in step 7.
   
   NOTE: The information is displayed erroneously, but it is not saved with the new record. Only new information that you add to the Time Worked box actually is saved with the new record.

Keywords : DcmOthr
Version : 97
Platform : WINDOWS
Issue type : kbprb