Hi,
I think us volunteers are having  trouble understanding how your form is set
up.
Below is some of the info you sent:
When you select (contractnum) on my form, it brings up all the information

associated with that "contractnum".  I have it set up when you select the

"contractnum" a new invoice generates for that specific "contractnum".  For

example if I select the "contractnum" A9000101F then a new invoice would

generate F1006.  The invoices generate Sequential.

I imagine that you have a form set to single form.

Make a selection from combo contractnum and the form uses a filter or find
first to show the details for that contractnum.

Is the above correct?

When the new invoice generates does the new invoice form open? how can
selecting a contractnum make the form show the details for that contractnum
and also generate a new invoice? please help me understand how your form
works.

Below is some of the info you sent:

Now, I have a Invoice Lookup box that looks up all the invoices.  Now what I
want to do is only look up the invoices for lets say "contractnum"
A9000101G, then what ever invoices would come up in the lookup box(G1002,
G1003, ect).  I have it where all the invoices pull up in the look-up box.
I want to only see the invoices by the "contractnum" I select.

Where is the Invoice lookup box? what form is it on? is contractnum a combo
on the same form?

Are we looking at a form with one or two subforms?

Jeanette Cunningham

Can you post a picture of your Relationship.  That would help.