Displaying more than one record on a form based upond underlying table

[gmillerinc]

I'm working with Access 97.

Go to

http://home.bellsouth.net/p/pwp-gregportal

Save the database db1.mdb onto your hard drive.

I want the form in the database to display "grayed" check boxes if a user checks a box, exits the form and comes back in. Currently only the first record in the underlying table is read or shown as "grayed" on the form.

You will have to save this database on your hard drive to be able to open it and, if necessary, covert it. It is in Access 97. Please help ASAP. Thank you!

 

[dalenz]

Hi gmillerinc,

Currently you are setting the check box's enabled status on the values of the first record in your table. Moving to the next record will not change these.

If you want to change the values based on the current record you need an on focus event for the check box.

But, I don't think Access will allow changing the enabled whilst it has focus. Makes sense.

However you can lock the check box.

Suggest you rem your on load event and try this code in the combo box on got focus.

If ([6-6:30] = True) Then Me![6to630].Locked = True Else Me![6to630].Locked = False

This will stop changes but doesnt grey out the box. You could also do this by code.

If I understand you want the user to select a specfic record, ie the one they last edited, then you would need to have an index in your table and select this in your form then select the record. Your on load code would then work but allowing users to cycle thru records would put you back to where you are now.

Hope this helps.