How to Change Allow Edits to No But Use Look-Up Combo

  • Thread starter Thread starter doyle60
  • Start date Start date
D

doyle60

I have a form with a look-up combo box. It was created with the
wizard.

I want users to add records but I don't want them to edit or delete.
So I set the Allow Edits and Allow Deletions to No and the Allow
Additions to Yes.

But this makes my combo look-up useless. It won't change.

Is there anyway to get this to work on the form?
Or must I use user permissions in security?

Thanks,

Matt
 
I have a form with a look-up combo box. It was created with the
wizard.

I want users to add records but I don't want them to edit or delete.
So I set the Allow Edits and Allow Deletions to No and the Allow
Additions to Yes.

But this makes my combo look-up useless. It won't change.

Is there anyway to get this to work on the form?
Or must I use user permissions in security?

Thanks,

Matt
Click to expand...

Turn AllowEdits back on but set the Locked property of all controls to True
(except your ComboBox of course).
 
This does not allow the user to add records. I want to allow them to
add records but not edit or delete records.

Thanks,

Matt
 
This does not allow the user to add records. I want to allow them to
add records but not edit or delete records.

Thanks,

Matt
Click to expand...

In the Current event test for NewRecord=True and then unlock all the
controls.
 
Back
Top