Need help autopopulating next new record with previous record data

  • Thread starter Thread starter Harry S
  • Start date Start date
H

Harry S

Hi -

I was asked to create a spreadsheet with a form that automatically
populates the next blank record with certain data values from the
previous record. The purpose is to save keystrokes. I've created a JWalk
Enhanced Data Form with some drop downs, but do not know how to get the
previous record to automatically recur in the next new record for
certain fields. Thanks in advance for any input.

Regards,

Harry
 
Harry,

This would probably be a fairly simple modification, but
you'd have to get access to the VBA code in order to
change it. This is protected, though you can get the
password for $20 from John's web site.

Cheers,
Dave.
 
Thanks Dave!

That's the news I wanted to hear. I just purchased the code two nights
ago and am becoming familiar with it. Any idea what good code might
look like? Thanks in advance for any input.


Regards,

Harry
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
User Form... built in form is so close...! 2
HELP: What is wrong with my For loop 4
Run-time error '380' Invalid property value. 1
Need combo box to refresh when moving to new record 2017 1
Update new record with previous record field 5
Excel 2003 VBA In directory Open Spreadsheets Extract data 1
Systematically Identifying Duplicate Records 1

Back
Top