DLookup on a text string

[richardwilder]

Hi, I have reached that "senior moment" time of life because the more I read other threads - the less I understand.

I have used the Dlookup syntax for adding detail lines to invoices for a few years, the source information has come from a Integer field product code which happily pulls the respective associated information across.

Now I have to pull stock items into a proforma invoice using the Mac address or other unique reference, but this time because of Hexadecimal Mac addresses I have to create a text based Dlookup.

I have attached a simple database and ask your advice.

Thanks in advance.

 

[plog]

I've got your database open, but can't understand what you need. What are you trying to do and where? Use the specific form and control you are trying to display data in, and then specific names of the field and tables to use.

 

[Mr. B]

Change the line where you are assigning the Criteria String to your variable to the following:

strFilter = "MACorID = '" & Me!MACorID & "'"

Notice the addition of the quotes, both single and double.

This will make the criteria to work.

Hi, I have reached that "senior moment" time of life because the more I read other threads - the less I understand.

I have used the Dlookup syntax for adding detail lines to invoices for a few years, the source information has come from a Integer field product code which happily pulls the respective associated information across.

Now I have to pull stock items into a proforma invoice using the Mac address or other unique reference, but this time because of Hexadecimal Mac addresses I have to create a text based Dlookup.

I have attached a simple database and ask your advice.

Thanks in advance.

 

[richardwilder]

Thank you very much I tried different combinations but not precisely that one!

Sorry for the delay in reply, the New Year happened!