Dlookup

B

Bill

Hi,

I have two tables that are has the same information but add person name as
additional fields in Table B not Table A.

Table A
Table B

I am searching Box number in Table A but it has some information in the
TABLE A. I would like to see the name of person from Table B that give a
pop up MESSAGE BOX to tell me who is the person while using Data Screen link
to Table A.

Your help would be much appreciated.
Thanks.
 
M

Mingqing Cheng [MSFT]

Hi Bill,

From your descriptions, I understood that you want correpsonding value will
be pop-up in message box while you are selecting from another Table. Have I
understood you? If there is anything I misunderstood, please feel free to
let me know:)

Could you show me a example providing the scenario that I could make it on
my machine? I am not very sure about your Forms and Tables so that it's
very hard for me to provide a sample How-To. It is highly appreciated if
you could send me a small sample file with the structures and sample data.

If you want to know how to use DLookup, you could refer to Access Help with
the topic words 'Dlookup Function'

Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 
M

Mingqing Cheng [MSFT]

Hi Bill,

I am just checking on your progress regarding the information that was sent
you! Have you tried the steps I provided to you?

I wonder how the testing is going. If you encounter any difficulty, please
do not hesitate to let me know. Please post here and let me know the status
of your issue. Without your further information,it's very hard for me to
continue with the troubleshooting.

Thank you for your patience and cooperation.


Sincerely yours,

Mingqing Cheng
Microsoft Developer Community Support
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top