Filling combo box text box area from data 
Author Message
 Filling combo box text box area from data

Look at the Column property - this will probably be more efficient than
accessing the underlying tables (eg DLookup).

HTH



Quote:
> Hi!

> Perhaps one of the gurus out there can help me with this.  I have
> created a form with several combo boxes.  The combos are keyed to
> lookup tables.  They display text data, and use numeric IDs to fill
> the data table.  I want to display the data in the table.  

> I have set up a recordset, selected the record for display via SQL,
> and wish to convert the IDs back to their text values.  Using DLookup,
> I can fill the text boxes which are linked to the combo boxes.  But
> the combo boxes come up blank.  

> Here's some sample code:
> myLookupTable:
> fldTableTextID           fldTableTextCode            fldTableText
>       1                     "S"                         "Stuff"
>       2                     "O"                         "Other Stuff"

> DataTable:
> fldTableTextID          
>       1

> With rs

Forms!myForm!cboFirstComboBox=DLookup("fldTableTextCode","myLookupTable","Ta
bleText
Quote:
> ID = " & !fldTableTextID)

Forms!myForm!txtFirstTextBox=DLookup("fldTableText","myLookupTable","TableTe
xt

- Show quoted text -

Quote:
> ID = " & !fldTableTextID)

> If the first record of the DataTable is selected via SQL,
> txtFirstTextBox, which contains the text equivalent of fldTableTextID,
> will correctly display "Stuff"; cboFirstComboBox should display "S",
> but does not.

> Any thoughts?

> Thanks in advance.
> Michael Dimen     MCP win95 Excel 5.0
> \\\\\\\\\\\\\\\\\\\\\\\|||||||||||||||////////////////////
> "Yes...I think it can be very easily done!"   Bob Dylan
> ///////////////////////|||||||||||||||\\\\\\\\\\\\\\\\\\\\



Thu, 04 Nov 1999 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Help filling second combo box from fist combo box

2. Help filling second combo box from first combo box

3. Vb 4.0 Problems updating Text Boxes from Combo Box linked to Data Control

4. enter data in a combo box based on value from another combo box

5. Combo Box like Data Bound Combo Box?

6. Limiting Access to Text Boxes, List Boxes and Combo Boxes

7. Viewing long text in combo box list area

8. Viewing long text in combo box list area

9. Filling combo box with Excel data...

10. fill combo box using data in msflexgrid

11. fill combo box using data in msflexgrid

12. Highlighting data in the text portion of a combo box and overwriting it upon data entry

 

 
Powered by phpBB® Forum Software