Can Anyboody Here Help with Locking restrictions that allow certain edits?

[CassandraB]

This is very confusing and hope I make sense in my explaination...........

I have a database that uses 2 forms and a subform. The first form and subform is used for viewing purposes only, but the way I get to the record that I want is that I've created a control text box where you type in or scroll down and choose a number to select it (all other data then populates the rest of the fields after it is selected).

But when I set the 1st form so that the records cannot be edited I can't use my search box because it won't allow me to type in it. If I change it so that I can use the search and lock the individual fields in my subform, it works for the 1st form (viewer) but I cannot use the second form (which is the editable form) because the subform is locked for edits.

I guess my question would be, how would I lock the entire 1st form, including the subform, but will allow me to type in the search control to find the record that I need. And in the 2nd form, that will also allow me to edit the subform (cuz when you lock a subform it locks it for use in any form, right?)

I hope you all understand my question, and will appreciate any help anyone has.......by the way, I'm a beginner, so be gentle in your explainations. Thanks a bunch!

 

[Sam Summers]

Hi Cassandra,

What I use is, on your viewing form, a button that opens a small form containing your searchbox. This small form is set so that you can enter your search parameters into it.
From this form you can set it to open your other form from a query based on the data you entered.

Does this shed any light on your problem?

 

[George Too]

You said:
"how would I lock the entire 1st form, including the subform, but will allow me to type in the search control "

My approach is to use code to lock just the controls I need to lock and leave the rest editable, in this case would be your text or combo box.

You said:
"(cuz when you lock a subform it locks it for use in any form, right?)"

Not to my understanding, but then, if you use code, you can use the same form and subform, given a criteria, and lock the controls if the criteria is true or unlock them if the criteria is false.

I believe that this approach will help you do what you want.

Regards,
George