Multi field search forms

[Rogue]

Hi there! Hope this message finds u all well.



I would like to seek your kind assistance for my below concern.

I have a table for orders list containing the supplier, items purchase,date purchase, amount, qty. NOw I would like to create a form wherein it would display all transaction for a particular supplier and particular date as selected.

Your revert is highly appreciated.

Thanks in advance and have a nice day.

Rogue

[pbaldy]

One method is demonstrated in the sample db here:

http://www.baldyweb.com/BuildSQL.htm

[Rogue]

hi, can anyone pls help me correct the below dlookup formula, i've been trying this in my attendance table several times but its not working

=DLookUp("[Name]","employee","[Emp ID]= " & [Emp ID])


I have two tables 1 is employee table and 2 is attendance table. the first table contains all details for employee like Emp ID, Name and etc while the next table contains all time ins and outs, employee code and etc.

THank you very much in advance.

[sdel_nevo]

Hi Mate

try this

=DLookup("[Name]","[emplyee]","Emp ID=" & "[Emp ID]")

Steve

[Rogue]

Hi mate,

Thank for you kind response, but i'm still having error on that. Could you help me further? please see screen shot I've attached for this error.


Attachment 12343

[sdel_nevo]

Hi

can you send over a copy of your DB for mwe to take a look at?

would love to help

steve

[sdel_nevo]

Hi Mate

have you tried putting that code on the form and not in the tables validation field?

steve

[Rogue]

yeah mate, in form it was working. but I need it to work in table as well coz I a have a form with subform that looks like below. I tried to send you the whole dbase as well but it seems that only images can be attached here.
Attachment 12345

[sdel_nevo]

hi mate

just sent you a PM

Cheers

steve

[Rogue]

hi mate just sent u my db


tnx

Rogue

[sdel_nevo]

Hi Mate

Hope the DB I sent Fixes your problem

Steve