Search results

Just set an unique index on the (order line?) table.

I am thinking about a model like this:

No doubt it "works". But that doesn't mean it's a schema that accurately reflects reality. See my remarks on "results". Plus, you don't want to enter your teams every season, as this model requires. A team can participate for several seasons, possibly in different divisions.

As this is about darts I assume a fixture consists of a number of matches between 2 players of each team. A "result" for one player doesn't make sense in that scenario. The OP doesn't mention individual games or anything like that. He only seems to be interested in the total result of al the...

And what if a team is promoted or relegated to another division? Or a player transfers to another team? Isn't history interesting?

In that way a team can only be involved in ONE fixture. That is not what you want. A fixture only should hold two foreign keys to team: home team and away team (as you seem to have). No junction table needed. No fixtureID in team.

What is messy here, is your table design. Placing multiple values in a field is a guarantee for problems. I also wonder what should happen if there are two or more values in the field that are interesting. Now you select the one you happen to come across first.

What is the use of the requery?

Welcome. That sounds pretty ambitious for a beginner. I wonder whether it is wise to build something like this yourself when there are so many ready-made solutions available.

Or ............ Remove the button and make the field(s) empty and click "search".

Try Null instead of ""

As said, data is stored in tables. I only see one form so in don't know what you mean with "if it found in other form". If the other form is the table "Other_Details", that table should not hold the Emp_name as it should only be stored in the Employee table.

Or ............ In the criteria of the function you can put: Between Nz([Forms]![MeetF]![txtFrom],DMin("Meetdate","MeetT")) And Nz([Forms]![MeetF]![txtTo],DMax("Meetdate","MeetT"))

I don't understand your data model. By working with two tables, you give the impression that one invoice can include several services. However, I couldn't figure out how to enter it.

I'm afraid this explanation doesn't really help. I see you have a main form linked to the tblDocCertKolone table. You do not show any data on the main form, but there is a filter ([KID]=1). You will therefore only see one record on the sub form. In fact, you only need one form to enter data...

I don't understand what the point is. If you are talking about a subform, then I expect that there are at least two tables in your database. However, I only see one. So you will have to explain yourself in more detail.

I assume that the invoice number is assigned via some code. In any case, we need to understand that in order to be able to say something sensible about this problem.

How simple can it be? At least so simple that I couldn't think of it 🤢

The code should do that. Of course you need to replace "YourDate" with the name of your date field. Unfortunately I can't test it today.

We do not see your data and we do not know how and where you are using the expression. So it is hard to tell what the problem is.