Combobox display records

[Ivan Grozney]

Shawna,

You should be able to restrict your combo box by
adding a restriction something like this:

forms!forminventory!partno=InventoryDetails.partno

on your query for your combo box.

hth
Ivan
alovercast@yaho

-----Original Message-----
Hi all,

I have a ? regarding how to display records in a combo box for a user to choose from.

On a form I have a field PartNo. Then I have another field - my combo box - HeatNo.
One part number can have multiple HeatNo. The PartNo and

HeatNo is stored in an Inventory details table.

What I have right now is the combo box displays all heat

numbers in the inventory details table.

What I'd like to do is show only HeatNo's for that

particular partno on the sale (for issue purposes). I've
tried using the where clause for i.e. forms!frmname!
controlname and tblname!fieldname but then this gives me
the heat numbers for any part that is on that form.

I'd like just the heat numbers for the current record the user is on i.e.

Sale Items HeatNo's (in invdet tbl)
Widget 123, 456, 789
Thingy 222, 333, 444

Right now I would get in my combo box 123, 456, 789, 222,

333, 444 to choose for either part.

 

[Guest]

Thanks, I tried that and it didn't seem to work. But I found the problem. I had to requery on enter to find the new matches

Thanks for your help