DBCombo Question

[Skrmetti]

I am having a problem with the DBCombo control. I can get it to work fine when the DataSource and RowSource controls are the same, but when they are different the combo box is empty. The form is a data entry form containing several text boxes. I am trying to add the DBCombo so the user can choose the value of the field in the table the data entry form applies to from all possible values, which are listed in another table. I am new to this, but as I understand it.

I have two relevant data controls, datDeviceRS and datPrimaryRS. datDeviceRS links to the Device table, which contains the field DeviceNumber. datPrimaryRS links to the Cable table, which also contains the DeviceNumber field (every cable is assigned to a device). I want the user to be able to choose from all the DeviceNumbers contained in datDeviceRS when entering data to the Cable table.

As I understand it, for things to work as I wish I should have the DataSource set to datPrimaryRS, the DataField set to DeviceNumber, the ListField set to DeviceNumber, the RowSource set to datDeviceRS, and the BoundColumn set to DeviceNumber. Yet when I try this configuration, the combo box turns up empty. When I switch the DataSource to datDeviceRS, the combo box works fine, except futzing around with it has no effect on the displayed record (or anything else that I can notice).

I am very new to this, and I have been working on this for about eight hours so far(I have moved from combo box to a very ugly attempt at using the TrueDBGrid and TrueDBCombo to the DBCombo, which seems the right choice) and I think I'm approaching success, but I'm really stuck with the data binding. If anybody could give me a hand I'd really appreciate it.

Thanks,
Jonathan
e-mail me at [email protected]

------------------
"Black?"
"For over thirty years."

[Skrmetti]

I forgot to mention that the datDeviceRS is a regular data control and the datPrimaryRS is an ADO data control. I am not sure that this matters, but at this point I'm not sure what matters regarding my problem. Ugh.

Thanks,
Jonathan

[Skrmetti]

Me again. I have solved the problem by using a text box to mediate between the target recordset and the DBcombo. So an answer at this point is nice but not neccessary. I am curious, though, as to whether or not it is possible to use a DBcombo, or any sort of combo box for that matter, by itself to perform the same task. If any resident gurus could enlighten me, I'd appreciate it.

Thanks,
Jonathan

------------------
"Black?"
"For over thirty years."