Locking fields

[Icewolf0927]

Hi
I have a form that is using a datagrid view. I was wondering is there a way to limit was I unlock or lock. I am trying to put some restrictions in that prevents people from using a field when they are not suppose to. I have created a macro that after the field has been updated depending what it is selected it unlocks the next field. The problem I am having is that it doesn't just unlock it for that one one but it unlocks them all. Is there a way to have the macro on impact that one line?

Thanks
Andy

[NTC]

Generically (or conceptually...maybe) ; a continuous form has 1 name for a control (in design view you see only one row)....but when populated with data you see continuous/multiple rows....

therefore you can not control 1 row's field from a macro or high level command point; but what you can do is control that 1 row's field when you are writing/tabbing in that row. So you put the vb in an event in a field - perhaps the AfterUpdate or OnExit event...and when you are in that individual row the code will affect that individual field.

but of course you do need to remember that if you lock/unlock a field while in its row - - and if you don't want to leave it in that state (affecting other rows) then you must trigger a reversal of that.....

hope this helps.

[Icewolf0927]

Thanks I think I get what you are saying. Let me see if I can get it to work.

[Icewolf0927]

thanks NTC your suggestion worked.