Microsoft KB Archive/207766

= ACC2000: The Time Cards Subform Is Not Filtered with New Records =

Article ID: 207766

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q207766



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

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
The information in this article applies to a database that you create 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.



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) Start Microsoft Access, and then open the database you created using the Time and Billing Wizard.
 * 2) In the Database window, click Forms under Objects, and then click Time Cards.
 * 3) Open the Time Cards form in Design view.
 * 4) If the Field List is not already open, on the View menu, click Field List.
 * 5) Drag the TimeCardID field from the Field List to an empty space on the Time Cards form.
 * 6) If the property sheet is not already open, on the View menu, click Properties.
 * 7) Set the Visible property of the TimeCardID text box to No.
 * 8) Save the form and close it.

When you click Enter/View Time Cards on the Main Switchboard, and then attempt to type new data, the data from other records is not displayed because the subform is now properly filtered.



Steps to Reproduce Behavior
 Start Microsoft Access, and then click the Access database wizards, pages, and projects option in the opening dialog box. Click OK. In the New dialog box, click the Databases tab, and then select the Time and Billing template. Click OK. In the File New Database dialog box, select a folder in the Save in box, type a file name for the new database in the File name box, and then click Create. Click Finish on the first screen of the Database Wizard. When you are prompted to type your company information, click OK, and then type Acme Supply in the Company Name box. Close the My Company Information dialog box. On the Main Switchboard form, click Enter/View Clients.</li> On the Clients form, type Frank in the First Name box and Johnson in the Last Name box. Then click the Projects button and type Shelving in the Project Name box. Close the Projects form, and then close the Clients form.</li> On the Main Switchboard form, click Enter/View Other Information, and then click Enter/View Employees.</li>  Create the following new records by typing the data below in the appropriate fields: <pre class="fixed_text">  First Name            Last Name ---  John                  James Sara                 South Close the Employees form. </li> On the Forms Switchboard form, click Return to Main Switchboard, and then click Enter/View Time Cards.</li> On the first record, select John James in the Employee box. Press TAB twice to move the cursor to the Date Worked field. Type 01/02/00, and then press TAB. Select Shelving in the Project list. Close the Time Cards form.</li> On the Main Switchboard form, again click Enter/View Time Cards.</li> Click the New Record navigation button, and then in the Employee window select Sara South. Notice that the date and project name entered for John James under Time Worked appears on the form.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 is actually saved with the new record.</li></ol>

<div class="references_section">