I'm teaching myself Database design, using MS Access (2007). This question may have a basic answer, but remember, I'm just a learner and it's not so obvious to me.
I would like to select a Company either by 'Name' or 'ID' or 'Account Number' in a Form and have all that Company's details such as Address and Phone Numbers change and appear too.
I have tried to do it in a Table using a Look-up list but only the company name changes .
Thanks in advance
touchngo
0
Newbie Poster
Recommended Answers
Jump to PostThe way I've done this in the past is by using a dropdown box and then VBA to code what happens when a name is selected from the dropdown box. Here is the VBA:
Private Sub Combo1_Change() Dim s1 As String If ((Me!Combo1.Column(0) <> "") And Not IsNull(Me!Combo1.Column(0))) Then s1 …
All 5 Replies
daltic
0
Newbie Poster
touchngo
0
Newbie Poster
timothybard
12
Posting Whiz
touchngo
0
Newbie Poster
touchngo
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.