Appreciate the feedback...
I've tried that - in various forms.
I've even created a completely new - unreleated database on another computer.
Compact it on that computer and access it thru mine.
Move it to mine and all others still have access to it - until I compact it. - Once I compact...
I have my program broken out into two
data
forms
the data sits on my computer
the forms - all 3 computers have their own copy of forms
All of a sudden when I compact and repair the data on my computer - it locks it up so the others canot use it. It can be used on my computer tho. No ldb...
Appreciate the response.
If I use continuous form I still have the same question.
How do a make the 'description' field be highlighted in a specific color when the 'Quantity Ordered" field has the focus?
I have an order form that runs in datasheet view.
What I would like to do is when I scroll down the 'qty ordered' column I would like the 'description' field that it applies to to be highlighted. (no particular color)
I am not new to Access but have pretty much stuck with macros - queries -...