Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, 
Author Message
 Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help,

Hi,
I have a small problem, and if you know the answer I would really be
thankful for your help.
I have an access database which is called "Client.mdb"
on a form, I displayed a dbcombox for the costumer's name
a textbox for the address
a textbox for the city
a textbox for the state
and a textbox for the zipcode
on all my textboxes and the dbcombobox I have set their Datasource and
Datafield properties to Data1,
when I run the program the information on the first record of the data shows
on the form,
but what I need to do is, when I change the costumer's name on the
dbcombobox (which displays all of the costumer's names on it) I want the
textboxes to show the address, city, state, and zipcode of the costumer I
have choosen,
Thank you in advance,
Enrique G Lugo



Fri, 23 Jun 2000 03:00:00 GMT  
 Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help,

Quote:

> Hi,
> I have a small problem, and if you know the answer I would really be
> thankful for your help.
> I have an access database which is called "Client.mdb"
> on a form, I displayed a dbcombox for the costumer's name
> a textbox for the address
> a textbox for the city
> a textbox for the state
> and a textbox for the zipcode
> on all my textboxes and the dbcombobox I have set their Datasource and

> Datafield properties to Data1,
> when I run the program the information on the first record of the data
> shows
> on the form,
> but what I need to do is, when I change the costumer's name on the
> dbcombobox (which displays all of the costumer's names on it) I want
> the
> textboxes to show the address, city, state, and zipcode of the
> costumer I
> have choosen,
> Thank you in advance,
> Enrique G Lugo


#1, when you post a message for help, put the context of the problem in
the subject line. ie... Subject: need help with database problem.

What you have to do now is to synch your textboxes with what is in the
data1.index...
So what ever the index # is then the text1.text should be = to that
field.index

If this doesn't help, I might have a vb4 routine that I could e-mail
you.

  vcard.vcf
< 1K Download


Sat, 24 Jun 2000 03:00:00 GMT  
 Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help, Help,

There should be some Data properties on your text and combo boxes which can
automatically update those controls with the record selected.
--
Ryan Faricy
RySoft

VB5 Site: http://ourworld.compuserve.com/homepages/rfaricy/index.html

The world keeps ending but new people too dumb to
it keep showing up as if the fun's just started.

John Updike - Rabbit is Rich

Quote:

>Hi,
>I have a small problem, and if you know the answer I would really be
>thankful for your help.
>I have an access database which is called "Client.mdb"
>on a form, I displayed a dbcombox for the costumer's name
>a textbox for the address
>a textbox for the city
>a textbox for the state
>and a textbox for the zipcode
>on all my textboxes and the dbcombobox I have set their Datasource and
>Datafield properties to Data1,
>when I run the program the information on the first record of the data
shows
>on the form,
>but what I need to do is, when I change the costumer's name on the
>dbcombobox (which displays all of the costumer's names on it) I want the
>textboxes to show the address, city, state, and zipcode of the costumer I
>have choosen,
>Thank you in advance,
>Enrique G Lugo




Sun, 25 Jun 2000 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. help,help,help,help,help,help,help,help,help,help,help,help,help,

2. Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,Help,

3. HELP HELP HELP HELP HELP HELPHELP HELP HELPHELP HELP HELP

4. PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP, PLEASE HELP,

5. HELP HELP HELP HELP HELP HELP HELP HEL P HELP HE LP HELP HELP HEL P HELP HELP

6. Help Help Help Help Help Help !!!!!

7. HELP HELP HELP Set document name of print job from VB HELP HELP HELP

8. HELP HELP HELP Early Binding Excel 5.0 HELP HELP HELP

9. HELP HELP HELP HELP HELP

10. Help - Print - Help -Print - Help - Print - Help - Print - Help

11. help help help help help

12. help, help, help...I'm begging here :-\ RE RE POST simple code help needed

 

 
Powered by phpBB® Forum Software