Re: Coding assistance needed for inventory database

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


"Mekinnik via AccessMonster.com" <u15466@uwe> wrote in message
news:5917f0bd316d8@xxxxxx
> 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 data*** 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
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200512/1


.

Quantcast