Can a Activex Control be record specific?

[nonprogrammer]

Hello,
I have an access Form and would like to append excel like documents I saw that under Insert there is an ActiveX Control and if you scroll down you find Microsoft Office Spreadsheet 9.0 in my case. I was wondering if there is a way to make this record specific because as of right now what ever I input in the Spreadsheet 9.0 I can see in all my records.
Any help is greatly appreciated.

 

[missinglinq]

I'm not sure of exactly what it is you're trying to do, but generally the way to make things "record specific" is thru code in the Form_Current sub,i.e. If a certain condition is met, make your ActiveX Control visible, otherwise make it invisible.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!