We are currently using a quotation file in access. When the new quote form is opened, drop-down lists are used to fill in customer information. Once in a while the customer has a different ship to address. How do we enter this information into the new quote form without changing the current record when the quote is saved??
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How not to update table?? and create new record
- Thread starter sdg
- Start date
create a new record is exactly what you'd have to do.<br>you'd jsut have to have the information that you want to keep transferred to a new record, and the rest of the fields left blank so that you can add the new address.<br><br>you could just create a button that takes you to a new record, and you could have it automatically pull the "keeper" info into the desired cells.<br><br>-i think this is what you're trying to get at. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
