I need help on performing a simple search by phone numbers....

[jransom1974]

Hello..............

I am needing to perform a simple search by phone numbers on my form, however, I need to populate sertain fields when the correct number is selected. Any pointers?

Also,.... I would like to post my database in my thread to allow others to download.... how do I do this please?

thank you for your help in advanced!

 

[John Big Booty]

You could use the DLookup() function to look up the additional fields you require based on the selected Telephone number.

To post your DB, first do a Compact an Repair on it, then put it in a Zip file. To upload it use the Paper clip icon at the top of the posting window the next time you make a post to your thread.

 

[jransom1974]

Thanks for the quick reply. I have uploaded my database, what I have been working on. I dont think I have used the Dlookup()... any adviced?
Also, if you look at the db I posted, I know there is a "lookup"field on the details page. It was there when I downloaded the db and havent changed it.

I would really like to hear your opinion on the corect way to go from here.

thanks again John!

 

[John Big Booty]

Sorry I can't open your DB what format is it?

 

[jransom1974]

Access 2010

 

[John Big Booty]

Sorry I've only got '07 or '03, are you able to save it back to either of those formats?