Access Form

[rbvcbr]

I want to create a form, in that form I want to put
dropdown box (customerid), when I select a customerid
I want to pull the data related to that customerid.
Pulled data will be, companyname, country, phone, etc..
Can you please help me on how to do this, or provide me some links to this kind of tutorial.
Thanks in advance.

 

[jedraw]

rbvcbr
Here is a good reference for many Access topics.

http://www.fontstuff.com/siteindex.htm#access

 

[PHV]

Why not just follow the wizards ?
Create a form based on your customer table.
Then, in the header section, create an unbound combo and choose the 3rd option of the wizard.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rbvcbr]

PHV,
Can you be little more descriptive, I tried it, for some reason it did not work. You are saying header section,
is it page header, or form header. PLEASE CAN YOU GIVE STEPS. IT WILL BE A HELP.
Thank you.

 

[PHV]

I talked about form's header.
I tried it, for some reason it did not work
What have you tried ?
Please, define 'did not work' (Error message ? Unexpected behaviour ? Computer crash ? ... ?)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rbvcbr]

First I created a combobox picking up customerid,
this works good, then I created textbox, for address and in properties, I put countrol source as 'address' from customer table, and for city text box control source as 'city' from customer table. It is not pulling address and city.

May may be I am doing something wrong in properties window.

 

[PHV]

So, you didn't follow any wizard ?
Reread carefully my first reply here as all the steps are given.

 

[rbvcbr]

I did followed as is, but I am ending up for address as 'combobox', as well city, but nothing showed up.
I am sorry to drag this.

 

[PHV]

Well, sorry, but I understand nothing in your last post.
Anyway, as you seem to not understand what the wizards are trying to do for you, you may have a look here:
faq702-3765

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[rbvcbr]

Dear PHV,
I went back again, I did exactly what you said in your first reply (Why not just follow the wizards ?).
It worked like a charm in few minutes.
I was doing something wrong before.

THANK YOU for your valuable tip.
rbvcbr

 

[lespaul]

thanks are usually shown by awarding a purple star by clicking on the link: Thank PHV for this valuable post! in any one of his posts.