Start Free Trial

asked on

DLookup to show multiple records on continuous form

Hi,

i am using the dlookup function in a text box and its giving me a one value. Can someone help me to modify the function which would give the result as multiple values.

attached is a copy of the database..

test1.mdb

DLookup can only return a single value.

From Microsoft's website (http://support.microsoft.com/kb/208786):

The DLookup() function returns one value from a single field even if more than one record satisfies the criteria. If no record satisfies the criteria, or if the domain contains no records, DLookup() returns a Null.

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Try this expression:

=DLookUp("Account","Query1","[State]=" & Chr(34) & [cmbmstate] & " and [juris]= " & Chr(34) & [cmbmjuris] & Chr(34))

mx

ASKER

Do you know or have any custom function?

ASKER

i was reading through the below link and the code wasnt working.

https://www.experts-exchange.com/questions/23375131/DLookup-with-multiple-records.html

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Also ... how do you get your form to populate with data ?

mx

ASKER

i didnt get your question DatabaseMX

DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

When the form opens, no records are showing. What are the steps to get records showing ?

mx

ASKER

select the state and jurisdiction in the drop down..

Hi,

you can of course use a recordset and assemble the wanted account numbers to insert it into a textbox. See the attached file for that.
test1.zip

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER

Not a complete answer i was looking for... but suggestion did help