The way I usually handle this is to put the combo box in the form header and on form_load I hide the form_detail section until they make a valid choice from the combo box.
Then you can use your permissions subroutine to mark each of the detail fields .enabled property to allow/deny editing. --- In [email protected], "anasbhai" <[EMAIL PROTECTED]> wrote: > > I got a form which is directly connected to a table with couple of > combo box . I created a user profile with a list of forms where I > defined who can view, add, edit certain form by some flag . When user > enters in a form a module read his/her permission & act accordingly. > The problem is I got a combo box which allows user to search certain > record so u cannot restrict user to edit record at the opening of a > form that if you restrict the user then he/she cannot search. So I let > the user to edit record at the got focus event of the search combo box > & in the lost focus event I run the permission function to restrict > user for editing any record but in the runtime the form do not act > accordingly , letting the user to edit or delete the record. I also put > the permission function in form's current event but no result. > > Please help > > Thanks in advance. >
