Check for existing date in record and duplicate record if date fou

W

Willie@PHS

BACKGROUND
I have a small db to record school calendar sales. db contains one table
Buyer Data with the following fields:
Calendar Number -Number (Preloaded with 000 - 999 (Thanks to Duane Hookom &
Rick Brandt)), First Name, Middle Initial, Last Name, Address, City, State,
Zip Code, Phone Number - All Text, Date Won - Date/Time. (Date Won is
considered a unique value - no dupes allowed.) A form, containing a combo
box for the calender number and all of the fields is used for data entry.
(Select Calendar Number from Combo, If a record exists - all data is returned
for editing, if no records exists - a blank form for data entry.)(All records
will filled upon completion of sale.) Currently user selects Calander Number
from combo box, checks record to see if Date Won is not null, if not null
creates a duplicate record using a command button. (There is a possibility
that a calendar number can win more than once.)
QUESTION
Is there a way using macros, VBA, etc. to check the record and see if Date
Won is not null, if not null create a duplicate record so date won can be
edited to reflect the latest date won? How?

Thanks for your help.
Willie
 
Top