Look-up Box Condition

  • Thread starter Thread starter aubrey
  • Start date Start date
A

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,
 
aubrey said:
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.
Click to expand...

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.
 
Back
Top