Can I hide duplicate values in an Access Form?

[Stephen Raftery]

I know that it is easy to hide duplicate values of a field in a report, but
can you do the same in a form? I have a db where I assign different staff
members to different tasks on various days. The form is sorted by staff
member: can I just display their name for the first record, and leave a blank
space for each subsequent record ?

 

[Daryl S]

Stephen -

You can use the form/subform capabilities. The main form would only have
the staff member, and the linked subform would show the other fields. You
can put the subform to the right of the staff name if that works better
visually for your users.

 

[Jeanette Cunningham]

You could probably go to a lot of trouble with queries and code to get the
form to look as you have described.
The simple and easy way is to use a form and subform.
The main form is for the staff member, the subform shows the tasks for the
person.
Use a combo box in the main form to select the staff member and the subform
will show all the tasks for that person.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Stephen Raftery]

Thanks guys, that is really helpful

Stephen

You could probably go to a lot of trouble with queries and code to get the
form to look as you have described.
The simple and easy way is to use a form and subform.
The main form is for the staff member, the subform shows the tasks for the
person.
Use a combo box in the main form to select the staff member and the subform
will show all the tasks for that person.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia





.