need to display combo box selection match on the form instead separate query/datasheet view

[newbieaccess203]

I created a form where it takes all the field from a table and displays.
than I created a combobox on header of the form and fill distinct value from one of the field of that table.
I wrote a code in combobox change() property which opens a query (query has condition will display record which matches with the combobox)

Every thing works fine except when I select selection from combobox to display the result instead of displaying in that form it opens new datasheet view and display the result.



I want to display the result in the same form in Tabular format.

please let me know if it is possible

[June7]

The query would have to be the form's RecordSource.

I prefer this method: http://www.allenbrowne.com/ser-62.html

[newbieaccess203]

if i put the query in form RecordSource than it does not work.
I removed the open query from combobox event (after change) and put the open query in recordsource of form properties. But if there is nothing in the combobox event than how it it is going to check what to open when you make combobox selection

[June7]

I NEVER use dynamic parameterized queries. My preference is the Allen Browne example.

Post the SQL of your query.

[newbieaccess203]

Database1.zip

So attach is Database1.zip file which has Database1.accdb database.
If you open it you will see 1 table, 3 queries, two forms, 1 macro.

By Default it should open MainFrm so double click on mainform to open it than you can click StudenFrm which will show you another form.
In the new opened form which shows the student list there is combo box on the top.
If you select the value from combo box (for e.g. north) it does open all the records which are in north region but....
Problem NO. 1 : it opens in separate datasheet window instead of on the same form in tabular format like you see in design.

how to get display on the form in same window instead of separate datasheet ?

[June7]

NOTE: merged threads

Answer is the same: query must be the form's RecordSource.

Modify WHERE clause to:

WHERE ((([Student1].Region) LIKE [Forms]![SubFrm]![Combo29] & "*"));

And change the button macro code to open form instead of query.

[newbieaccess203]

sorry about duplicate threads.....accidental...

but i made changes as you mentioned and now it is not doing anything when i make combo box selection.
can you please unzip db and check, as i am attaching db again.
thanks

[June7]

The combobox macro needs to refresh/requery the form, not open - the form is already open.

I couldn't figure out the macro - I don't use macros, only VBA:

Me.Requery

[newbieaccess203]

not sure why i can't make it understand.
Please ignore the macro which is in database, do not pay attention.
I have created macro to export the desired result to export in excel.
that macro has nothing to do with problem i am mentioning
None of my two forms (main and subform) is linked with macro. Neighther combo box is linked with macro.
Please do not get confused with additional objects in the database.
I just needed simply to refresh the data in the 2nd form (subform) instead of opening combobox selection in separate datasheet view

[June7]

I gave you solution. Need code (macro or VBA) to refresh/requery the form. I couldn't get macro to work. I provided VBA syntax.