continous forms

[JulieD]

Hi All

i have a multi-tab form with a continuous form on one page as a sub-form -
everythings fine, except i have a button on this sub-form that i want to be
able to change the caption for - if there is something in the company field
the button should read "view company details" if the company field is blank
(ie a new record) it should read "add company" - i don't seem to be able to
achieve this as, when the new record is selected both buttons change to "add
company" - is there any way of doing what i want, or alternatively, hiding
the button and only showing in on the active record?

Thanks
JulieD

 

[Larry Linson]

Don't show the button in the Detail. Show it in the header or footer of the
Form embedded in the Subform Control. Change the wording on one button, and
you change it on every row, because there is only one Detail record
definition -- all the others are just replicas of other records painted on
the screen.

Larry Linson
Microsoft Access MVP

 

[JulieD]

Hi Larry

thanks for that i'll give it a go.

Cheers
Julie