Help,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,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,Help,

just findfirst
ie:
with data1.recordset
        .findfirst "name = '" & cbo.text & "'"
end with



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




Fri, 23 Jun 2000 03:00:00 GMT
 
 [ 2 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

3. query:HELP! HELP HELP HELP HELP

4. SQL To ORACLE Help Help Help Help Help

5. Help help help help

6. HELP HELP HELP HELP!

7. HELP HELP HELP HELP

8. HELP HELP HELP !!!

9. HELP HELP HELP!!!!

10. SQL Selection - HELP HELP HELP

11. backup HELP HELP HELP

12. help, help, HELP!


 
Powered by phpBB® Forum Software