How to disable the ability to change a record

[curiousdesi]

Alright.

So I have this basic table that has student information. It is connected to other tables but that is not important in this question.

I created a query that shows the Student ID, First Name, and Last Name.

I then created a split form from the query.

Finally I added an unbound text box called search with a button next to that has a macros within it:

[LastName] Like "*" & [Forms]![SearchID]![Text14] & "*" Or [FirstName] Like "*" & [Forms]![SearchID]![Text14] & "*"

It works Beautifully!! Now here comes my issue:

1. I love that it searches for the name you type in and displays the record
2. What I don't like is that you can edit the record.

I tried to set the AllowEdit in the form properties to no but that also took away the ability to type in the search text box. Is there a way to allow typing in the text box but not allow changes in the record?

All help is GREATLY appreciated as I have to turn this in on Tuesday

 

[JHB]

Use the Locked, (and Enabled) property on each control instead of setting the AllowEdit property for the whole form.

 

[curiousdesi]

Thank you sooo much. I can't believe I didn't figure that out. I seriously have been breaking my head over such a simple solution :banghead:

 

[JHB]

He, he - good you got it at last!