Form Design Query

[info]

I have a database for producing quotations for customers. I have a
Quote Header table and a related Quote Detail table. There is also a
Customer table to store the customer details. To produce a quote for
a customer I need to be able to either select a record from a Customer
table or create a new record on the customer table.

I can produce a form with a combo box to lookup an existing record
from the customer table - where the form is based on the quote header
table with a related sub-table for the quote details. But I want to
be able to either select an existing customer OR enter a new customer,
using the quote form.

Is there any way to do this?

[Bob Quintal]

in**@alphabyte.co.uk wrote in
news:11**********************@r34g2000hsd.googlegr oups.com:

I have a database for producing quotations for customers. I
have a Quote Header table and a related Quote Detail table.
There is also a Customer table to store the customer details.
To produce a quote for a customer I need to be able to either
select a record from a Customer table or create a new record
on the customer table.

I can produce a form with a combo box to lookup an existing
record from the customer table - where the form is based on
the quote header table with a related sub-table for the quote
details. But I want to be able to either select an existing
customer OR enter a new customer, using the quote form.

Is there any way to do this?

set the combobox.limittolist property to yes.
when the new customer'sa name is not present, a message will pop
up asking if you wish to add it. Your code then should open a
small form to enter the customer details, save the newly entered
data to the customers table and set the response to
acDataErrAdded
see http://msdn2.microsoft.com/en-us/library/aa211431
(office.11).aspx
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com