Is there a way to get rid of Duplicates on a form

[John]

I have multiple phone numbers that relate to one office.
I do not need office information repeated, is there a way
to not show the multiple instances of the office
information in forms like there is in reports.

Thanks,
John

 

[Pavel Romashkin]

Yes, but you want to do it at the data level. Bind the form to a Group
By query - this will be exactly the same as if you used Grouping in reports.
Then of course the form becomes read only.

Pavel

 

[John Vinson]

I have multiple phone numbers that relate to one office.
I do not need office information repeated, is there a way
to not show the multiple instances of the office
information in forms like there is in reports.

Certainly; several ways. One would be to use a Subform for the phone
number table so you could see the office once, with all its phone
numbers visible; another would be to base the Form on a Totals query
(not updateable, however!) grouping by all the office fields and using
First to pick an arbitrary phone number.

How is your table structured? Do you <oops!> have the office
information and the phone information in the same table, repeating the
office info with each phone, or a one-to-many relationship?