If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I hide duplicate values in an Access Form?
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 ? |
#2
|
|||
|
|||
Can I hide duplicate values in an Access Form?
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. -- Daryl S "Stephen Raftery" wrote: 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 ? |
#3
|
|||
|
|||
Can I hide duplicate values in an Access Form?
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" Stephen wrote in message ... 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 ? |
#4
|
|||
|
|||
Can I hide duplicate values in an Access Form?
Thanks guys, that is really helpful
Stephen "Jeanette Cunningham" wrote: 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" Stephen wrote in message ... 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 ? . |
Thread Tools | |
Display Modes | |
|
|