Combobox issue

[maluna]

Hi,

I have 4 tables :

Model [ModelID, ModelName]
Description [DescID, ModID, Description Name ]
Parts [ PartnumberID,DescID,Partnumber]

Calls [cat, desc,number]

I built a dymamic combobox base on tables (Model, description and Parts ) which is working pretty well however the results which are being recorded on Calls table are showed only in ID's.

How do I get the values selected in my combobox ???? i.e


I have attached an image as example.

thanks in advance

 

[jdraw]

Take a look at
http://www.datapigtechnologies.com/AccessMain.htm
Then look at the tutorials for
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html
http://www.datapigtechnologies.com/flashfiles/combobox3.html

 

[boblarson]

Two things -

1. Don't upload photos to ImageShack or other sharing sites. Those are blocked from many of us while at work. Just upload them here and use them. See this for how.

2. Since I can't see your image, I can only guess that perhaps you have set up lookups directly in the tables and that is not good. They should be used on forms only. See here for why.

 

[maluna]

Jdraw, thanks a lot for those tutorials. I watch them all but in fact it didn't really help me since my combo box is working. What I want is extract from my combo box values instead of IDs remembering that they my combo boxes are dynamic.

just want as well to say thank you

 

[John Big Booty]

Isn't this a continuation of this thread

 

[boblarson]

Isn't this a continuation of this thread

It would seem so.

 

[maluna]

Yes, it is !

I am sorry if I screwed up. What I wanted is just clarify my problem which still not solved !

Cheers,

 

[John Big Booty]

Perhaps you could post a copy of your DB, and I'll take a look at it for you.

PS. please save it back to '03 version.

 

[maluna]

Here it's John,

Thanks is advance mate !

 

[John Big Booty]

Unless you save that back to Access '03, I'm not going to be able to open that to help you. As I don't have access to anything post that version.

 

[maluna]

Ups...I see what you mean now !

I've attached a '03 version.

Thanks !

 

[John Big Booty]

OK have a look at the new query I have added this should help you.

Now a couple of quick comments about naming objects. Firstly consider using a naming protocol such as TBL_TableName, for tables, FRM_FormName for forms, QRY_QueryName, and RPT_ReportName, this will make identifying the type of object that your code is referring to, once you get heavily into writing code, much easier. Also be constant with your use of field names. For example if ItemID is used in a number of tables to represent the same value, then use it constantly so it is apparent that that field is referring to the same thing in each table. This will also save you no end of confusion further down the track.

 

[maluna]

Hey John,

Do you know what ???? You are a genius !

Thank you so much !

My issue is finally solved. I'll bring it to my real db and of course consider your suggestions !

Thanks a lot !

 

[John Big Booty]

Excellent