Filter using query

[ChoonHong]

Can anyone help me with this issue:

I have a query form which runs like this:

Field: Division Diploma Modules Name Modules Number Level
Table: Module Module Module Module Module
Sort:
Show: „Ï „Ï „Ï „Ï „Ï
Criteria:Like ¡§BE¡¨

I have also create a subform query which based on this, a combo box which let the users choose the "Diploma" name.

My problem is althought all of this have been done there is no result return when i click on my combo box. How can i solve this?


(this is my source code for the combo box)
Private Sub cboDiploma_AfterUpdate()
Form.RecordSource = "Select Diploma from qryBE where Diploma='" & cboDiploma & "'"
Form.Requery

 

[HomeALone]

Two ways for you to try. . .

Method 1
1. goto the Properties of the combo box, under the Data tab
2. Ensure RowSourceType set to "Table/Query"
3. RowSource should have the query name spelt out-QueryName
now goto Format tab
4. make sure ColumnCount set to 3
5. make sure ColumnWidths set to 0";0";1"
6. make sure Width is at least 1"

or

Method 2
Delete your combo box, re-do it using the combo box wizard, read each word carefully while going through the wizard.

 

[ChoonHong]

Thanks for yr help!

I do it the way as u mention but it does not return the desired result i wanted~

The combo box does not filter out the results i want~ do i need to change anything to the subform (qryBE:i create a subform using qryBE)?