I really want the two seperate forms. One for quotes and one for Invoices.
Re read above - having problems linking these tables. Currently have the
Invoices table would like to add a field to the invoice table called quoteid
as a drop down. If there is a quote for an order they can choose a quoteid
from the drop down and it will automatically fill in SOME of the fields. So
Invoice person does not have to.

Thanks for your follow up,
Barb

"darkroomdevil via AccessMonster.com" wrote:

I am sorry, I scanned quick and I thought you were re-asking how to make
controls visible or not visible. But the above does answer your original
question, so there you go ...

I guess I need to know if you are in agreements for your needs in having a
separate Invoice and Quote tables or if you are going to use one Invoice
table with a status field. If you could specify this and then list the steps
that you would need ... it would be less confusing to be on the same page for
what to do before we try to get in to the how to do.

Roger

--
Message posted via http://www.accessmonster.com