Search results

In my country I don't think it will be allowed, or it will at least be in a gray zone.

Else post your database with some sample data, zip it because you haven't post 10 post yet. And write the name of the report.

If you can't get it then post your database with some sample data, (zip it) + the name of the report.

You build a query like in the link. https://edu.gcfglobal.org/en/access2016/designing-a-simple-query/1/

Are you using a Multi-Valued Field type?

Is the form a continuous form or a single form? What is the form's records source, a query or a single table? You can post your database with some sample data, (zip it) + the name of the form in which you've problem!

Is Me.txt_strHMP at text value?

Have you tried it on another computer, (not one from the production but another one in the office)? Should that be a text, (it is treated as a number)? Me.txt_strHMP

At which code line does the error occur?

Does it not run if you remove all about the "Active" or what is the problem then?

Maybe this: qdf.SQL = "Select * From [Query1] WHERE [Job Number] =" & Me.[Job_No_Combo]

You use the function wrong, here are some sample. https://support.office.com/en-us/article/dcount-function-f6b5d78b-ad0b-4e42-be7a-11a64acbf3d3

I've loaded your database, I can't see anything wrong with the cboGoTo, only that it doesn't show any value, but it is because you clear it the AfterUpDate event for cboGoTo. Me.cboGoTo.Value = Null 'Empty the Combo box When you choose a value from the list it brings you to that record.

You're welcome, good luck with your project, (your long-term database, your baby! :D). :)

Here is one idea how you can do it, I'm sure you're able to finish it.

Please could you post a printscreen when the form(s) are shrinked? Have you tried to work with the database at another computer? Is the database the only database that have the problem?

Is your form Edit able?

I totally agree! :)

The code is: Exit For

I'll have a closer look at it tomorrow.