Solved

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

Posted on 2002-04-24
3
168 Views
Last Modified: 2010-05-02
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
Comment
Question by:joyrider
  • 2
3 Comments
 
LVL 1

Accepted Solution

by:
asafmm earned 100 total points
ID: 6967750
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
 

Author Comment

by:joyrider
ID: 6968408
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
 

Author Comment

by:joyrider
ID: 6968528
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question