Allow data entry to a field on a form that doesn't allow edits?

[Dave14867]

Hello all,



I have an issue where I want to not allow edits on a form however I want to allow the user to be able to input a lot number in a combo box and search for that specific record. So far I haven't been able to do it, is there a way. The form is a copy of the Main input form I use to enter data, I then changed the properties of the form to not Allow Edits, not Allow Deletions & not Allow Additions. The idea is that users will be able to search for a record and look at the details but not be able to change any of the data in the record.

[Bob Fitz]

Hello all,

I have an issue where I want to not allow edits on a form however I want to allow the user to be able to input a lot number in a combo box and search for that specific record. So far I haven't been able to do it, is there a way. The form is a copy of the Main input form I use to enter data, I then changed the properties of the form to not Allow Edits, not Allow Deletions & not Allow Additions. The idea is that users will be able to search for a record and look at the details but not be able to change any of the data in the record.

What happens after making an enter in the combo that searches for the required record then.

[Dave14867]

In the new form, it doesn't accept any input. In the original form (That I use to input the data) I put in a lot # like 123456, and it will go to that record.

[Bob Fitz]

Try this in the GotFocus event of the combo:

Me.AllowAdditions = True
Me.AllowDeletions = True
Me.AllowEdits = True

And this in the AfterUpdate of the combo after the code that finds the required record:

Me.AllowAdditions = False
Me.AllowDeletions = False
Me.AllowEdits = False

[davegri]

As you have found, setting a form to not allow edits will also not allow combobox lookups.
One fix would be to set all the bound controls to Enabled=No

[Dave14867]

Bob,

That worked, Thank You. I hadn't thought of that.

Dave, I am sure your method would also work but I tried Bob's fix first so I am all set.

Thanks so much.

[Bob Fitz]

Bob,

That worked, Thank You. I hadn't thought of that.

Dave, I am sure your method would also work but I tried Bob's fix first so I am all set.

Thanks so much.

You're welcome. Glad to help if I can