Solved

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

Posted on 2002-04-24
3
170 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
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…

719 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