Search results

still the same error. here is the updated code ="Passenger_Name = '" & [Forms]![Agent]![cntPassDetails].[Form]![sect] & "'" am i doing it wrong somewhere?

Before trying the cuddly monster i have given a try to macro and now getting type mismatch error ="[CGS] = '" & [Forms]![Agent]![Passenger_Details].[Form]![sect] & "'" CGS is of type text Agent is main form Passenger_Details is subform on main form sect is the searchbox

no doubt :) lucky me

i tried a trick with combobox and changed the subform master field to combobox name. now the records are filtering. but i need them to filter through textbox. so is there any trick like the combobox one to filter records on demand through textbox?

its only referring to controls on forms. how to use these when searching through textbox and button on main form :/ the monster (vb) is biting me :P

thanks .. going to give it a try:)

is there any alternative way rather than VBA? like query etc?

the vb code is :banghead: for me :P can you suggest if any macro code that will do the trick ?

I want to find a record in a subform via texbox and button. The search box is working fine on main form via macro on the button but i am unable to set cotrols to find data on the subform the macro ="Passport_Number= '" & [Forms]![Agent]![sect] & "'" what should be the reference to search in...

Got your point and others too. This will not happen again in future. My apology to all senior members 🙏🏻

I understand what you have said and also taking responsability of the mess i have created with my attitude. I am guilty on the act but saying that the senoirs should also keep their calm and try to bear questions of aprentice like me. No harsh feelings for anyone :)

Thanks for taking time and posting the screenshot. I will apply this security to the files and folder of database. Bundle of thanks ❤️

I will check it tomorrow when i get back to office. and i am was not asking for quick help or something like that. All i wanted is a healthy answer like you are doing right now which leads me to the actual problem solving solution. I mean what it will be worth if you are taking your precious...

THanks for the suggestion. i will look at the security of files in the shared folder. The file menu setting is already changed and shared folder has read write access. But i havent changed the security settings of files in that folder. (Silly Me) :banghead: And as for moroon :D i was fedup...

I am currently getting this error after splitting and sharing the db

sorry didnt noticed your comment while reading some moroon's comment. I have replied to that question and will wait for your suggestion. Thanks :)

ahan! lets see if you can find me :D:D

yes the db is splited into BE and FE . I got a vb code from another member of the site and its working 80% regarding my query. Can you suggest other way than VB? or it is the good one.

they didnt even reffered to already answered question. All they did is point out my double post and showed their cheap mentality. They are forgetting that there are people who are willing to help in either case.

lets see how far it can go. I had created 4 id on this forum just for the users like you who always cry for nothing. Ignore what you cant see :cool::D