allowAdditions = False

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a work around to the allowAdditions = False problem where the screen
goes blank?

I want the user to open a form and only be able to work on the record if
they have clicked on the edit button. But with allow additions set to False,
the screen comes up blank. If the form has only the allowEdits set to False,
they can add data to a new record without clicking the edit button.

I also need to force them to click edit as I have code that checks if they
have rights to edit and add new.

Your help is greatly appreciated. Thanks Rob
 
Enable and lock all the controls on the form, then display the data. You'd
need to provide programming to unlock the desired controls for editing, or
(my preference) pop up a form that displays the record selected for editing
and then let the user edit it in the popup form (be sure to requery the
first form when done editing in the popup form).
 
I'm confused by your statement:

"with allow additions set to False, the screen comes up blank."

Under this condition (AllowAdditions = False) the screen only comes up blank
if the form's Record Source is empty! If there are records to be shown,
they'll be there!
 
the form is not a continuos form, it only shows and allows edits to one
record. When the form is opened and if there is not already an existing
record, a new one can be added. So if I set the allowAdditions = false, the
form comes up blank and the control to allowEdits (cmdEdit) and
allowAdditions (also behing the cmdEdit) is not visible. Any ideas would be
greatly appreciated. I thnk ken has the right approach. Thanks, rob
 
I've not had to tackle this in a while but if I remember correctly you need to
put cmdEdit in the form header or footer to ensure that it is still there when
there is no record.

HTH
John
##################################
Don't Print - Save trees
 
Back
Top