Search results

You've forgotten to post the database the 3 of the tables are linked to, so it isn't possible to run the form.

Are you sure the filter you build return any records? Show all the code you've in the OnLoad event. If you can't get it post your database with some sample data, zit it.

Or post your database with some sample data + name of the form where the button is. Zip the database because you haven't post 10 post yet.

Have you not read the Lookup field type in a table is No Go? That is your problem. http://access.mvps.org/access/lookupfields.htm

Try in the error handler to resume to the same code line, remember to put a breakpoint in that code line where the Resume is, then if it is a time issue it will execute.

The last one is wrong: Expression is [Text24] <14 Should be: Expression is [Text24] >14 Post your database, zip it:

You're welcome, good luck with the "bigger problem"! :)

I think the On Close event is to late, move the code to the On Unload event.

Post your database.

How "strong" should it be? Does it allow people with some knowledges of MS-Access to "break" it?

You are wrong about that, so ... some of your other statements could be wrong to. Excuse it sounds negative, it's not really the meaning, it should only make you think about it an extra time, if there may be other places where you might be wrong.

In which form do you've the code when you click it first time and also the second time? If you can't get it post your database with some sample data, zip it!

Post your database with some sample data + name of the "problem" form!

Why do you've all that buttons on the form? Could a combo box not work for you?

And what problem do you have with that if any?

Sorry - looking at your tables I don't see any BIN 1234 or field cs3/cs4. :confused:

Yes you posted a printscreen how you want it but not which data there are involved and how they are related to each other.

Have you looked at the attached database in post #16, is that what you want?

Click at the new button in the form, is this what you want?

Could be a corrupt form/database. Try a "Compact & Repair" Decompile the database, https://www.fmsinc.com/microsoftaccess/Performance/Decompile.asp Create a new database and import all into it.