Question

Asked on 2003-08-04 at 10:19:43ID: 25036708

Combox & Textbox populate.

by: LOUISBOUDVILLE125

Rating7.8Very Good

I have some problems with  Combobox fields populate. I have a table ItemCode with 5 fields.
The fieldnames are : itemid              integer
                                 itemcode          char         3
                                 descrip             char         40
                                 fcamt                numeric    10,2
                                 rmamt              numeric    10,2
 Records are as such.
           itemid      itemcode    Descrip                    fcamt      rmamt  
             1            001            Freight                   20.00      80.00
             2            002            Documentation       15.00      60.00
             3            003            Break Bulk               30.00    120.00
             4            004            Terminal                  5.00        30.00
and so on.....


My problem is this :

I  have a form tcbofrm with a combobox and a textbox. The combobox rowsource = ItemCode.itemcode, rowtype = 6
I have a text box "txtdescrip" with rowsource = ItemCode.Descrip, rowtype = 6.

When I select itemcode 003, It is display onto the combox as "003" and I expect the text box to display "Break Bulk"
but instead it display "Freight" which is the first record descrip field. So whenever I update the comboxbox, the textbox is
not being update with teh same record fields of the combox list.

How do I make it to also to populate the textbox as "Break Bulk", whenever I select in the combox "003" for itemcode ?
In other words, whatver record select but with the fields of the same record to populate for the combox and textbox ?


Louis
   

Related Solutions

Solution

Access this solution immediately by signing up as a member of FoxproAnswers.com--it’s quick, easy, and secure. We will return you to this solution, unlocked, when you’re done.

About this Solution
Sign up Now to View This Solution
Zone
general
Tags
populate combox rowtype textbox
Participating Experts
2
Solution Grade
A

Replies

 by: altman80

Posted on 2003-08-04 at 10:36:46ID: 26246637

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: LOUISBOUDVILLE

Posted on 2003-08-04 at 10:51:43ID: 26246638

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: suhashegde

Posted on 2003-08-04 at 10:54:29ID: 26246639

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: suhashegde

Posted on 2003-08-04 at 10:57:35ID: 26246640

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

 by: LOUISBOUDVILLE

Posted on 2003-08-04 at 11:05:21ID: 26246641

All comments and solutions are available to Premium Service Members only. Sign up to view the solution to this question. Already a member? Log in to view this solution.

Log In

Forgot your password?Sign up

Top Experts

  1. pcelba

    4,240

    0 points yesterday

    Profile
  2. mozner

    2,000

    0 points yesterday

    Profile
  3. mbarbir

    1,912

    0 points yesterday

    Profile
  4. jrbbldr

    1,500

    0 points yesterday

    Profile

BrowseAre you an Expert?