Coding assistance needed for inventory database

  • Thread starter Thread starter Mekinnik via AccessMonster.com
  • Start date Start date
M

Mekinnik via AccessMonster.com

Happy Holidays to all,

I am trying to query a table based on the users selection from a populated
combo box. I would like to have the code filter a selected field(combo box
selection) from one or even multible tables. The returned information I would
like to be read only and be viewed as a datasheet or possibly a populated
form with X amount of records which would be filled with the information from
the query.

I would prefer to hard code it all in as opposed to using the installed
wizards.

Thanx for all the assistance

Mekinnik
 
you can write your query, and then bind it to a form (i'll call it
frmQueryDataset) to show the query's return dataset. then create another
form (i'll call it frmChoose), put your combo box on the form (i'll call it
cboSelect), and add code to the combo box's AfterUpdate event to open the
first form, as

If Not IsNull(Me!cboSelect) Then
DoCmd.OpenForm "frmQueryDataset"
End If

in the query's design view, set criteria on the selected field, as

[Forms]![frmChoose]![cboSelect]

hth
 
Back
Top