Is there a view mode???

[purchaandr]

Hey there all,

I know there is an Add and an Edit mode in which you can open and view forms but what I really need is a form which can be opened and viewed where absolutely none of the fields can be touched or edited. I don't really want to write code based on a condition which will then go line by line setting each textbox etc to disabled!


Thanks for all your help once again!

Andrew

 

[namliam]

Find the properties of the form and set it to "Allow updates" to No
And/Or "Locked" yes.

Good luck

 

[purchaandr]

Hey there,

thanks for your help. I can't seem to find the allow updates property but I have found the allow edits, allow additions etc and that works a treat. I assume that is what you mean!

Thanks once again namliam!


Andrew

 

[namliam]

update, edit... same difference

Sorry about the mixup

 

[purchaandr]

Haha don't worry about it mate, you put me 100% on the right track and I fixed it up.

Cheers, Andrew

 

[gemma-the-husky]

it probably wont matter, but even if updates is set to no, you can still change any field with code, and you might need to be aware of this

 

[purchaandr]

Hey there guys,

I have been trying to get this working but havent managed to figure out how to do it using VBA! I have a button which opens the form so you can view it but not be able to change anything.

Any Ideas on how to change the form controls using VBA?

 

[missinglinq]

Change the form controls how? And how are you opening it so that it's in Read-Only mode?

 

[purchaandr]

Well the form usually isnt read only and is fully functional but I want to be able to open the same form from a different menu and have it read only. The code I am using so far is:

[Forms]![frmViewOpportunity].Form.AllowEdits = False

This works, however there is a text box on my form where I need for a search function and it means that I cannot type in any text to search through my records

 

[gemma-the-husky]

you could open the form with openargs at a certain value

then depending on that use this sort of code

for each ctrl in me.controls
if ctrl.name<>"certain field" then
ctrl.locked=true
next

 

[purchaandr]

Hey there guys,

I used a less than desriable solution but it works, kind of stemming on from gemma the husky's result. I had a flag set to one, very similar to the open args method and whilst the flag was set to 1 all the from controls edit functions were set to false. This also set my search box to be untouchable as well so I just used the on focus event to enable it and the lost focus event to disable it.


Cheers once again guys!