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

[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

 

[Rick Brandt]

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

Turn AllowEdits back on but set the Locked property of all controls to True
(except your ComboBox of course).

 

[doyle60]

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

 

[Rick Brandt]

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

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