combo box

[rollover99 via AccessMonster.com]

I have a form 'Home Dept' that opens from autoexec that has a combo box bound
to a table column called 'HomeDeptID' that has 2 choices Sales or Purchasing.


I want the combo box to open and filter a form that uses the ID from these
choices to limit the records shown to the homedeptID.

The form is called QCPC and has a text box that is called HomeDeptID in it.

I have read many threads and just cannot come up with the code to do this.
Right now I have a

AfterUpdate code that can open the form. I lack the knowledge to set a
filter that applies when it opens and is removed when it is closed.

Any help on this would be appreciated.

 

[Larry Daugherty]

FWIW if your Autotexec macro exists solely to open the form, put the
form name in your Startup Options and get rid of the macro. Be that
as it may ...

Open a *copy* of the form that is currently first opened & that has
the existing combobox in Design View. Open that section of the form
vertically to allow space for a new combobox. Make sure that wizards
are enabled. Click the combobox icon and then draw a new combobox on
your form. Step through the wizard answering questions. You want a
form operation that opens a named form with a particular record in
view. ...

HTH

 

[rollover99 via AccessMonster.com]

All set thanks...