Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

Data Combo Question (how to make it work like a combo in acces)

Okay this is what i try to do

imagine u got 2 tabels one named cars and one named cartype

cars is linked using FkCartypeId wich holds the id of the record in cartype

so u basicly choose the type out of a nr of types (comming from that table cartype) in the datacombo and then u save the id of the type u choose in the table cars under fkcartypeid.

This i got working without a problem, What i don't can't get to work is the changing of it

so u got both them tables again and there already some records in table cars, and u want to change the cars type for those records also using a combobox

so i want the original one to be seen in the combobox along with the others (in the list) wich u can choose

this is what i did :

i made a recordset for the rowsource of the datacombo (select * from cartype) and set the listfield to cartypename (so u see the typ's name)

ok that's np, now getting the current value for it in the combobox what i did was setting datasource to a recordset (select cartypename,fkcartypeid from cars,cartype where fkcartype=pkcartypeid) and as datafield i choose fkcartypeid  and as boundtext pkcartypeid.

now when i run it it works like i wanted it (i see the original selected value in the datacombobox and i could see the other options in the list) but when i change it to another type, it doesn't get saved, and when i try a recordset (the one for the cars table) .update or .requery i always get errors

so my question is how can i get this working ?? like this way it more ore less like it works in access but i want it this way in VB (i'm connecting to mssql server btw)

please help thanks !

c'mon someone must have made something like this it's pretty basic but i just Can't GET IT TO WORK correctly

all i want that it works like in access that's all :(
0
joyrider
Asked:
joyrider
  • 2
1 Solution
 
asafmmCommented:
Dear joyrider

FIRST - make sure that your data source are well set (readonly for the cartype and dynamic for the cars).

SECOND - set the data combo properites as follow :
    DataSource - the cars RS
    DataField - the CarTypeID field from the cars RS
    RowSource - the CarsType RS
    BoundColumn - the CarTypeID field from the CarTypes RS
    ListField - the CarTypeName field from the cars RS

THIRD - it is not good to keep the CarTypeID and CarTypeName in the cars table (unless the values in the CarTypes table my change) because it is redundent !!!

Thanks
Asaf
0
 
joyriderAuthor Commented:
That doesn't work !
That's how i had it set , except for the Readonly for cartype and dynamic for cars(ure talking bout locktype & cursortype here right ?), but i changed that and it still doesn't work, yes when u see the default value and yes u can select others from the combo but no it doesn't save and no u can't call requery with out gettin an error

ow and i didn't have cartypename in my cars table, think i must have explained it wrong somewhere

btw could this bug be a cause why it's not working correctly :
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q251225
?
0
 
joyriderAuthor Commented:
Okay i tested it with the ADODC control and there it seems to work so it has to be something with my code (i'm not using the adodc control)
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now