Look-up Box Condition

[aubrey]

Good Morning All,

I have a from "General" and a subfom "ProposedReg," I have a relationship
that connects the two so that when I select a Reg on the General form the
related ProposedReg come up on the subform.

I would like to create a look-up box on the ProposedReg from that would
look-up the Proposed Regs. The problem that I've encountered is that when I
create a look-up box it lists all of the Proposed Regs that I have in my
table, I would only like it to list all of the Proposed Regs as it relates to
the Reg that I selected on my General form.

If anyone can point me in the right direction, that would be great.

Thanks,

 

[Mike Painter]

Good Morning All,

I have a from "General" and a subfom "ProposedReg," I have a
relationship that connects the two so that when I select a Reg on the
General form the related ProposedReg come up on the subform.

I would like to create a look-up box on the ProposedReg from that
would look-up the Proposed Regs. The problem that I've encountered is
that when I create a look-up box it lists all of the Proposed Regs
that I have in my table, I would only like it to list all of the
Proposed Regs as it relates to the Reg that I selected on my General
form.

If anyone can point me in the right direction, that would be great.

What is the relationship between a "reg" and a "proposed reg"
When you say "look up box" are you tlking about a listbox or a combobox?

In any event the "look up box" should have the same criteria that the form
subform does.