Open Form for New Record?

  • Thread starter Thread starter LJG
  • Start date Start date
L

LJG

Hi Guys,

I have a form frmQuote that I want to open and create a record from the main
customer form, I can call the table, the problem I have is that the form
does not add a quote number for each record I create?

Table is one to many

quoteID (Autonumber)
contactID (Primary)
df1 (Date)

any help would be appreciate....I should know why this is not working but
cannot get my head around it this morning

Thanks
Les
 
Hi Guys,

I have a form frmQuote that I want to open and create a record from the main
customer form, I can call the table, the problem I have is that the form
does not add a quote number for each record I create?

Table is one to many

quoteID (Autonumber)
contactID (Primary)
df1 (Date)
Click to expand...

the quoteID will get a new Autonumber, but the contactID is empty (if
you don't write it)
if you filter on the contactID it looks like you didn't got a new
Number, because it's Null
 
Maybe need to add that the form that opens is made up of a number of tabbed
subforms, all using orderID, however, even if I open the form to start a new
record it still does not produce a new record number in tblOrders.

thanks
Les
 
Maybe need to add that the form that opens is made up of a number of tabbed
subforms, all using orderID, however, even if I open the form to start a new
record it still does not produce a new record number in tblOrders.
Click to expand...

now you are using a field OrderID ?

bevor you had:

try all what you want in a query and see what will be the result
 
No Sorry, quoteID should have been orderID ,

sorry for the confusion, the form is called quote
 
Back
Top