subforms

G

Gary

Website: http://www.databasedev.co.uk/query_filter.html shows how to select
an item in a combo box - which will open a seperate query results form.

I'd like to be able to have the search and results form together ie.
subforms.
So effectively, by selecting the item in the combox box, the results will
immediately show up just below the combo box without the need to open the
results in a seperate window.
I tried to create a new form with both the search and query forms setup as
subforms in this new form but had on luck in making it work.
Can anyone suggest a solution.
 
L

Larry Linson

Gary said:
Website: http://www.databasedev.co.uk/query_filter.html shows how to
select
an item in a combo box - which will open a seperate query results form.

I'd like to be able to have the search and results form together ie.
subforms.
So effectively, by selecting the item in the combox box, the results will
immediately show up just below the combo box without the need to open the
results in a seperate window.
I tried to create a new form with both the search and query forms setup as
subforms in this new form but had on luck in making it work.
Can anyone suggest a solution.
Click to expand...

One of the options in the Combo Box wizard will do most of what you want,
but expects the information to be displayed in the bound fields of the Form
in which that Combo Box is located. If you'd rather it be in a Form embedded
in a Subform Control, just use a standard (unbound) Combo Box as the
LinkMasterFields for the Subform Control. You may have to Requery the
Subform Control in the AfterUpdate event of the ComboBox.

Larry Linson
Microsoft Access MVP
 
Top