| Darhl Thomason 2006-03-29, 6:56 pm |
| I think I answered my first question by myself. If I want to use a
DataCombo on my form, then I also have to use the ADODC control to populate
the data, correct? I tried coding the DataCombo when I was opening the
connection and recordset manually, but when I ran the app, it gave me a
compile error "Method or data member not found" in this line:
cboOwner.DataSource = rsPOSData
But I can assign it when I use an ADODC.
Any way, on to my real issue. In my main data table (tblStoreData) I have
relationships to other tables. For example, I have tblStoreData.OwnerID
which relates to tblOwners.OwnerID which also has .OwnerName and .OwnerEmail
and .OwnerPhone. I have a DataCombo working that ties these two tables
together properly, but only for the .OwnerName field. The other fields I
want to be text boxes not combo boxes. If I set them all to DataCombo's
then they do work semi-correctly, but each separate field is a combo box,
effectively letting me change the owner's phone number to a different owner.
I only want the .OwnerName to be a combo box so if a store changes owners, I
can select the new owner from that DataCombo and the other text boxes update
appropriately.
I was able to do this in Access '03 VBA, but can't quite get it to work in
VB6.
Thanks for any advice!
Darhl
|