wildcards

[THOMASM4425]

I am somewhat new to access programming. I am working on a small database for work where we will quote our products. i created a form in which i can select a customer from a drop-down and it will assign a new quote number automatically. we can then add part numbers to the sub form and create the quote. we have standard products which are available in the part number field of the subform. however we also quote many custom products that we will only quote 1 time and i do not want to assign new part numbers to each custom item. instead id rather have a "wildcard" if you will in order to have one part number IE "special" where i can manually enter the info without it changing the previous quotes with that "special" PN. any ideas? please see attached picture




Tom

[burrina]

So, if it is a NEW record or a one time Quote, use code to eliminate the Part Number. Is it auto-populated? You could of course generate a unique PN if the criteria is met.

If Me.NewRecord = True Then
'Do Something

How are you determining or will you determine if it is a One Time Quote?