I think the command button for the append query may work. A few things
though my invoice # in the invoice table is not assigned until the report it
is based off of the date the report is printed out. My primary keys for the
invoice are Clientid and ticket# together. Plus when you are at the quote
pt. not sure if there will ever be an invoice generated for that quote.

Back to the append query. Not sure how to set that up. Do I make the
command button in design view of form(no wizard for this?) - go to the event
procedure of the on Click- Think I can just make the append query in the
query area- how do I Call it????is that the right word???


The user origanlly asked me to give them a drop down with quoteid so they
could pick it and it would fill in the fields- sounds like it should work but
not sure how????
Maybe they would get a list of quotes for the quote guy or the customer
would have their quoteid that they are actually now going through with and
they can pick it from the drop down. Would rather prefer doing it this way
if at all possible???????
Thanks again for your input.

"darkroomdevil via AccessMonster.com" wrote:

As an added thought, how does the user know whethter to look in the drop down
list for quotes or not?

In that scenario you are sitting in a new invoice anyway, so you might as
well do it from the quote form.

The only exception is if you are not talking about the quote /invoice but the
invoice sales detail, in other words line items of what they are purchasing
that are quoted for the customer that you wish to now ad to the invoice ...
just brain storming to make sure we are on the same page.

Roger

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/200512/1