How to synchronize 2 DBCombo boxes in VB 4 16 bit using Access 2 
Author Message
 How to synchronize 2 DBCombo boxes in VB 4 16 bit using Access 2

 I have a feeling that you are using the exact code

Select Maintopic, Subtopic frm tblSubtopic WHERE
Maintopic = Me.DBCOMBOMaintopic

If you reflect a minute, what will Me.DBCOMBOMainTopic be equal to??
Probably not what you want it to...you need to get the data currently being
displayed in the DBCombo which you can get via the Text property;

Select Maintopic, Subtopic frm tblSubtopic WHERE
Maintopic = chr$(39) &  Me.DBCOMBOMaintopic.Text & chr$(39)

The Chr$(39) 's are the single quote character. If you need more, email me
and I will try to get you thru it...

John



Tue, 01 Feb 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. How to synchronize 2 DBCombo boxes in VB 4 16 bit using Access 2

2. corruption of 16 bit db when used by both 16 and 32 bit apps

3. Help: attaching Btrieve-table in Access mdb using VB 4.0 16-bit

4. Using VB 4.0 16-bit mode to interface with Access 7.0

5. Help: attaching Btrieve table in Access 2.0 database using VB 4.0 16-bit

6. Compiling a 16-bit executable using 32-bit VB.

7. Using 16-bit dll's in 32-bit VB

8. Accessing 16-bit DLL from 32-bit VB

9. Connect 16-bit VB app to 32-bit Access 97 DB

10. VB 4.0 (16-Bit)/Crystal Reports 3.0.1.32 (16-Bit) Print Preview Maximize Window

11. How can I access 32 bit access with 16 Bit Visual Basic ( VB 3.0 or VB 4.0 16 bit)

 

 
Powered by phpBB® Forum Software