Opening of Form Code

[scott04]

Hey Everyone,
Is there a way that i can code my form so that when it opens the "Filter
for:" box pops up for one of my fields so i can go right to that record? The
users of my database do not want to be able to view all records of the form.
They want to only be able to add new records or edit specific records. This
is why I am hoping at figuring out how to honor their request. Thanks

 

[Jeff Boyce]

One approach to accomplishing this is to add an (unbound) combobox in the
header of the form, and in that combobox, list the available-for-edit
records. Use the combobox's AfterUpdate event to requery the form. Use a
query to populate the form that looks to the form's (new) combobox for a
parameter.

This way, when the form first opens, the combobox is empty, so the form's
query finds no records and loads that. Then the user picks an item from the
combobox, the AfterUpdate event triggers, re-querying the form, which now
has a (selected) record.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[scott04]

Thanks Jeff. Now i have a good starting point to try and complete this task