search in form

[2bulent2]

hello

i made some columns in the form so the users cannot change them but just view.
but when i make a search with find button it doesnt search these passive columns

how can make it to serach all the columns?

 

[jamaarneen]

Hi

I don't really understand a few things:

- what do you mean by [blue]"some columns in the form"[/blue]? are they separate listboxes or combo?, or maybe is the form in 'datasheet' view?

- [blue]"it doesn't search"[/blue]: how does it know what to search, and what should happen after it finds something?

 

[2bulent2]

sorry i used wrong words. i dont know access well and dont know the english meanings.

i just made a form with form wizard and it takes data from a table

this is the screenshot (the names are in turkish)

http://bulentt.info/resim/form.gif

"kay?t bul" means "find record" (or something like it)

when i click on this button i can find the records

http://bulentt.info/resim/find.gif

but as all the fields other than "HESAP NO" are not accessible it cannot find data of these fields.

if you like i can send the mdb file after preparing it with enlish version.

thanks

 

[jamaarneen]

Sorry, but I can't see the screenshots you tried to link

 

[2bulent2]

http://rapidshare.com/files/261438701/form.rar.html

i hope this will work

 

[2bulent2]

any answer?

 

[jamaarneen]

Hi 2bulent2, sorry for the delay.

What i think is, that in order to prevent the user from change, you have set the property Enabled = No and the property Locked = No, and that's why the 'Find' can't find it.

I suggest you should try like this: property Enabled = Yes and the property Locked = Yes, that way it will be able to find.

the only difference will be, that if both properties are set to 'Yes', then the use will be able to enter in the textbox, but NOT change its value.

Helped?
Ja

 

[2bulent2]

thanks for the answer
i found this solution yesterday but forgot to write on form, sorry.