Answer abuot Combo Box

[mojahed.mroteza]

hi guys first excuse me for my language becuse im Afghan


i have 2 comboBox in My forms One of them name Duty and it get data from tab_emp ;and others combo name is state and get data from other table
I will when i chose duty(for example:teacher) ,comboBox state just show data about teacher(for example:techear-calss1,techear-calss2,techear-calss3)
model
Database51 (en).zip
tank u for all

[June7]

These are dependent comboboxes. Review this tutorial http://datapigtechnologies.com/flash...combobox2.html

[mojahed.mroteza]

tank u for ur answer but this answer for 1 table my form have 2 table please review my form tank u my master.

[June7]

Doesn't matter that two tables are involved, concept is the same.

The Group and Duty fields hold the common linking data. You have the Group field in Tab_Grade as text and save the descriptive value from Duty field of Tab_TypeEmployment, not the number Grade. However, the Duty combobox is bound to the number Grade field, not the Duty field. Since the State combobox must refer to the value of Duty combobox as criteria, no records will return because nothing in Group will match the Grade values.

Need to either save the Grade value into a number field of Tab_TypeEmployment or remove the Grade field from RowSource of Duty combobox. Since the Duty values are short could just keep saving them in Tab_TypeEmployment and eliminate the number Grade field. Why is Grade just a number type, not even autonumber?

RowSource for State combobox:
SELECT Tab_Grade.[Tab-emp], Tab_Grade.state, Tab_Grade.tm FROM Tab_Grade WHERE (((Tab_Grade.Group)=[Forms]![Form1]![CboVazife]));
You retrieve 3 fields but have set for 2 columns.

You have 'student' in Tab_TypeEmployment but 'students' in Tab_Grade.

[mojahed.mroteza]

do u have any sample from this project???? thank u

[June7]

Just make the changes I described.

Duty combobox properties:
RowSource: SELECT Tab_TypeEmployment.[duty] FROM Tab_TypeEmployment;
ColumnCount: 1
ColumnWidth: 1"
BoundColumn: 1

State combobox properties:
RowSource: SELECT Tab_Grade.[Tab-emp], Tab_Grade.state, Tab_Grade.tm FROM Tab_Grade WHERE (((Tab_Grade.Group)=[Forms]![Form1]![CboVazife]));
ColumnCount: 3
ColumnWidth: 0.5";1";0.5"
BoundColumn: I am not sure which value you want the combobox to have
Width: 2