wrong search results

[June7]

Why would Form1 even have a RecordSource? Again, don't see need for Form2 to have RecordSource either.

Yes, I modified table and now your query works. I just wouldn't use this method at all.

[guest]

sorry combo boxes are not translated i will fix them than send you new one.

[guest]

Here it is final version. Search.zip

[guest]

Well at the time i was learning how to do it example was with recordsource so i did that way. form2 was copied from form1 and then edited or vice versa.

[mike60smart]

Hi
The frmLedgerSearch in the attached is another method of searching records within a Split Form

[guest]

Mike I downloaded your version. Nice and clean but how it works. tried searching not response. should I change something.

[mike60smart]

Hi
You type whatever you want to search for and then hit the Enter Key.

Once you finish searching you hit the Clear button to clear the filter.

[guest]

I tried nothing happened. which field is should search and why not responding?

[guest]

after enable content it start working but not searching all fields and there are sometimes mistakes in searching.

[mike60smart]

Hi
The Controls which are in the Search String are as follows:-

[BasicNumber]
[NameOfRecipient]
[Transfer]
[NumberDate]
[DateOfReceipt]
[OrganizationalUnit]
[Content]

If you type John and hit the enter key it will return 1 Record

If you want to search on other Controls then you would need to add these to the After Update event of the Search Box

[guest]

Thanks I will try all that. I have material to study. Thanks again.

[guest]

Mike I added two more fields. they work fine but I have still problems with date of receipt field. if I search for date 22-12-2024 I get empty record. Solution?

[Welshgasman]

Works for me?, which I suprised TBH, as dates normally need # surrounding them

[guest]

I am not sure why not for me. this date fields are big trouble. i GOT IT. it accept only date format 22.12.2024.

[guest]

Guys thanks for help this is it I am closing this now. thanks to all of you.