Sub-Form - Don't show active record

[Steve R. via AccessMonster.com]

I have a form that users can input / edit all open contracts with vendors -
there are many cases where there are more than one contract, and I have it
set up so the user sees the detail on the screen for just one record, plus I
have it linked to a child sub-form by vendor that shows all contracts for
that vendor at the bottom of the screen.

Problem is, it also shows the current contract being viewed on the screen in
the sub-form running across the bottom of the screen - can I filter my sub-
form so it doesn't show the current record being displayed ?

Steve

 

[Guest]

In the criteria for the subform query use the following --
<>[Forms]![YourMainForm]![YourTextBoxDisplayingKey]

 

[Steve R. via AccessMonster.com]

I'm sorry, you'll have to 'dumb it down' a bit - What do you mean by
[yourTextBoxDiplayingKey] ? Is that the Parent / Child link ?

In the criteria for the subform query use the following --

I have a form that users can input / edit all open contracts with vendors -
there are many cases where there are more than one contract, and I have it

[quoted text clipped - 7 lines]

Steve

 

[Guest]

It should have read --
<>[Forms]![YourMainForm]![YourTextBoxDisplayingMainForm Contract]

I'm sorry, you'll have to 'dumb it down' a bit - What do you mean by
[yourTextBoxDiplayingKey] ? Is that the Parent / Child link ?

In the criteria for the subform query use the following --

I have a form that users can input / edit all open contracts with vendors -
there are many cases where there are more than one contract, and I have it

[quoted text clipped - 7 lines]

Steve

 

[Steve R. via AccessMonster.com]

I'm sorry I don't know what you mean by
"[yourTextBoxDisplayingMainForm Contract]"

My form name is ContractInputNew

So my criteria starts out <>[Forms]![ContractInputNew]!

But what text box would you be referring to ? And what field do I pick to
put the criteria filter under ?

Sorry - I appreciate your help, but I'm not that skilled with sub-forms.

Steve

It should have read --

I'm sorry, you'll have to 'dumb it down' a bit - What do you mean by
[yourTextBoxDiplayingKey] ? Is that the Parent / Child link ?

[quoted text clipped - 7 lines]

 

[Guest]

Your form (ContractInputNew) has some kind of field that displays the
Contract number does it not?
The identification of that field is what I am referencing.

Open the query that is the record source for the subform in the design view.
The first row of the grid list the fields to be outputted or controlled.
Below the field that has the contract in the Criteria row of the grid put the
criteria.

The criteria tell this query to output records that are greater (>) and less
than (<) that being displayed in the main form.

I'm sorry I don't know what you mean by
"[yourTextBoxDisplayingMainForm Contract]"

My form name is ContractInputNew

So my criteria starts out <>[Forms]![ContractInputNew]!

But what text box would you be referring to ? And what field do I pick to
put the criteria filter under ?

Sorry - I appreciate your help, but I'm not that skilled with sub-forms.

Steve

It should have read --

I'm sorry, you'll have to 'dumb it down' a bit - What do you mean by
[yourTextBoxDiplayingKey] ? Is that the Parent / Child link ?

[quoted text clipped - 7 lines]

Steve