Locking Columns of Rows

M

Mike

I have a form containing a subform. The Subform is in datasheet view and
cantains columns; SelectSite(LookupFromTable), DateFrom(Date Value),
DateTo(Date Value), Book(Yes/No box). When Book is ticked true the values of
SelectSite,DateFrom,DateTo are used to performs actions on tables. However
when these values are changed it won't result in the tables being changed
again but will record the change on the form. To stop this i wanted my tick
box to generate using code a function that locks the columns
SelectSite,DateFrom,DateTo Only on one row. I have tried using code to lock
each one but this locks the entire column because it is in datasheet view.
Htis problem has been killing me for weeks. Please Help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching Between Dates 1
Date Parameter problem not showing correct info 2
date range question for todays date 0
Separating out months in a date range 1
Parameters and crosstab queries 4
Combo box won't display correctly 1
Default Value when input data 3
Date formats in DLOOKUP 2

Top