Subform

D

Double A

I would like to create a subform as a spreadsheet that has 2 columns. The
first column uses a drop down menu to choose a category (using a 2 column
combo box). I would like to have the choice made in the drop down menu for
category to automatically populate the second column, Info. The table
structure for this is as follows:

tblWorkLineItem
--------------------
WorkOrderNumber
LineItem Number Key field
Category uses look up table
Step uses look up table

Each category may have many steps.

Please help me with how to set this subform up. It needs to be connected to
the WorkOrderNumber.

Thanks.
 
G

Golfinray

Check the info of Martin Green at www.fontstuff.com or Allen Browne at
www.allenbrowne.com. Both have good info on that. Or you can use a filter.
Set up your combo box with the wizard selecting the fields you want in the
combo from the appropriate table. Build the subform with the wizard to show
your desired fields. Set it to datasheet view so it will look like a normal
form. Go into the events of the combo properties and on afterupdate go to
code builder and type"
Me.filter = "[thetableorqueryfieldyouwanttofiter] = """ & Me.yourcombobox &
""""
Me.filteron=true
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top