Please be more specific. See Rule #2.

Please be more specific about what does not work. Can the users enter data in the boxes? Do they get an error message when they hit the search button?

Also, please share the VBA code you used in the search button.

Thanks Sami
They can enter data but when they click the button 'Search' absolutely nothing happens. No error, nothing happens.
I'm putting the code here but only showing 1 of the boxes to shorten it here.
Private Sub cmdFilter_Click()
    Dim strWhere As String
    Dim lngLen As Long
  
    If Not IsNull(Me.txtFilterLastName) Then
        strWhere = strWhere & "([LastName] Like ""*" & Me.txtFilterLastName & "*"") AND "
    End If
(the same for the other boxes)
        Me.Filter = strWhere
        Me.FilterOn = True
    End If
End Sub

Not sure how to edit posts here but I should have said the Search button is called cmdFilter

Is it in a Trusted Location

Put just a MsgBox in a simple button. Does that work?

I have had this problem in previous versions a MS Access where buttons work in accdb files but not accde files.  Look in your VBA code for  any subs with no executable code.  Delete the sub.  Compile the executable again and it works.

Regards

Ron de Boer Geelong Victoria.

PS Richard, Sharma and the rest of the moderators don't leave blank subs in thjere code therefore they never see this happen.

Compile

I wonder if maybe I should just give up :( !  Don't know what msgBox is, or what a 'Sub' is or 'Compile'.
I am still learning but in the meantime what I've done for the harder stuff so far is taken VBA codes from other databases and templates and adapted them.
But actually I can't give up because the database I've created is loved by my colleagues and has saved loads of time faffing about with excel spreadsheets, and notes and stuff!
So any more explanation would be really appreciated :)

A few videos have been linked, have you watched/tried them? Or are you having trouble doing what's in the videos?

Trusted Location
MsgBox
Compile

Hi, OK to narrow down where the code is that you have this non executable sub routine I suggest the following. 1. Create a brand new database. 2. Click External Data, New Data Source, Access Data Base (Select Your Database where your tables if you have a split database otherwise your accdb file) and select import *** not link ***) and import your all your tables and queries.  These most likely won't be the problem. Then select your Login Form and/or the first menu on load. Select one other form. Save the database. Give it any name. Click File Save As and create your accde file.  Run the accde file and click on a button that either loads your 1st menu or the form you also imported.  If the button works then you know these forms  *** Do not have the problem I described.  Import say 5 more Forms using the External Data process. Compile again, close open and run again. If the 1st button works you know these 5 forms are OK. You do not need to run each form.  The form (mostly likely where the problem is) being compiled (creating the accde file) by being in the accde causes the problem.  Keep adding forms until your buttons stop working.  When it does open each of the last 5 forms loaded in your accdb file and search through all the VBA code and look for a sub or function that has no executable code.  Eg  Private Sub xxxx() then nothing or just comments and the End Sub .  Delete this Sub Routine Save the accdb and recompile. Run the accde if your buttons work, Problem fixed.  IF not load accdb and look for more blank subs.  Continue until you have deleted all blank subs and functions. Slow and painful but it works. Kepp loading all the Forms Reports (Reports can have VBA code) and Modules until until the whole system is loaded.

Regards
Ron

As I said earlier Rick the Moderators and Shammi are old hands at this I have finally learnt to be careful (most of the time) Stick with it. Access is a great product!

Hi Jennifer, I am happy to go through in a Teams session if you like and show you what I mean.  Don't have to use your database we can even use one of Rick's test databases. I'll even show you the problem if you like.

However I am in Australia and we would have to work out a time.  I don't work fulltime therefore I'm flexible most days but obviously need to sleep.

Regards

Ron

Hi All, thanks so much. I've attached how the form is.
I did , Compile - nothing happened - All trusted location is all trusted and Msgbox is N/A.
Thanks Ronald, I did what you said, created a new db, imported tables, then imported menu and the form that has the issue. Saved and ran, all working ok, saved to accde  and same thing. Nothing happens, no message and reset doesn't erase.

Ronald Thanks so much Ron, that would be awesome! The boss of the company is my husband so I can do what I like haha! so any time that suits you, I can fit in.

Ronald I tried to test your theory, and I created a blank subroutine in the TechHelp template. It worked just fine when I converted it into an ACCDE file. This may have been a problem in older versions that I wasn't aware of. I've never heard of it before, but it apparently is not a problem anymore in the latest version of Access 365.

Hi Ronald. I had that problem once, and the other moderators helped me with it. It was on an older version of Access. Now I use Access 365, and that problem no longer exists.

Hi Jennifer,
Sorry for the delay.  I have my head in creating my own LLM (ChatGPT).  Yes you can if you have a high powered PC with a GPU. Which I do!  However back to your problem. You are 9 hours behind me so as I write it is 4:49PM here. Happy to help you up until 10PM my time which is midday your time. Any night. If you want to SMS me on +61 404 857 805.  I use Teams works really well for me once it connects. Do you have a microphone on your PC so we can chat as I show you what I know and believe is your problem. I also have Viber which you can call. Anyrate SMS or call to get together to organise best way forward.

Regards

Ron de Boer

Thanks Ron, Teams is ggod, will sms you
In the meantime, I watched Richard Rost's video on Search Form, (just so's you know I'm doing my homework!) I did exactly what he did with the query, and everything he did. All worked great, but when I saved as ACCDE  nothing happened again, and no error message. :(

Jennifer have you performed an Office Update recently? Make sure you've got the latest version.

Hi Jennifer, I agree with Richard in the newer versions and Richard is always on the latest I believe this problem has been resolved.  Your probably on aversion that had this problem.  It's a little bit of a process but worthwhile doing so you understand what you have done.  Having seen what you have done you will understand why this problem is happening to you. Look forward to sms and helping you out.

Regards
Ron

Richard  Hiya, I and the 5 other users have Office 365 Business and they are all setup to Update and install Automatically. And just to be sure, I've just checked it is and this is what the version is.
Microsoft® Access® for Microsoft 365 MSO (Version 2505 Build 16.0.18827.20102) 64-bit

Hi Jennifer, Sorry for the delay.  I have my head in LLM and AI at the moment as well as my MS Access stuff.  I still say let's get together so I can show you what I mean. What you have described is exactly the problem I have had in  the past and I have been able to help 1 or 2 other people with what you have described as the problem my fix resolves.

Again apologies for the delay in responding.

Ron