2 combo box linked

[cikwan82]

Hi ,
I already make table like this in access

Status Analysis Price
Student Dry 100
Student Wet 150
Student Cold 200
Officer Dry 200
Officer Wet 250
Officer Cold 300

and i also try to make 2 combo box with 1 text box
[combostatus (Student/Officer)] [comboAnalysis (Dry/Wet/Cold)] [textprice (appear automatically)]

example1: [student] [Cold] [200]

i already try to link each other using relationship and combobox different table, but still not working.. please help me..

 

[ltdan58]

If im understanding you correct ... you want two combo boxes to communicate with each other ... when you change one it narrows the results in the second combo box? if this is what you want then you need to go to the second combo box and go to rowsource under data and click the "...", then go to SQL and type a query to narrow the results ... example: I have a tblcity which has 2 fields (city, county) and i have tblcounty ... I have one combo box with county and one combo box with cities ... if I only want to see the cities in that county this is the code i write in the SQL ... SELECT tblcity.cityid, tblcity.city
FROM tblcity, tblcounty
WHERE (((tblcity.county)=[tblcounty].[countyid]) AND ((tblcounty.countyid)=([forms]![Search]![combo4])));

 

[Mihail]

In a normalized DB you need 3 tables in order to store the information that you show us.

tblStatuses
ID_Status - AutoNumber (PK)
Status - Text

tblAnalyses
ID_Analyse - AutoNumber (PK)
Analyse - Text

tblPrices
ID_Price - AutoNumber (PK)
ID_Status - Number (FK on tblStatus)
ID_Analyse - Number (FK on tblAnalyse)
Price - Number; Double

 

[cikwan82]

Thank you Mihail and itdan58, you are very smart guy.. actually if posible i want to create 2 combobox and 1 textbox similar like Mihail did, but no need filter button. The price automatically appear in Price textbox, it is posible to doing this? i'm very happy an lucky if u all can do this..
This i attach pic what i want to do..

 

[Mihail]

See how txtPrices is changed when you Status and Analyse.

 

[cikwan82]

God job my friend.. i dont know how to say thank.. very thankful from me.. this is what i want to do.. thank you very much...