Starting from scratch - need help on new form design

[skiefer]

Hi all,

I've spent lots of time over the past month developing a database that does exactly what I need it too, except for one problem which no one seems to be able to resolve. So ... i'm going to start from scratch and get some up-front advice on how to design this application.

I need to create a very simple data entry form that will allow users to fill in the fields, then save the data to a new row in the db, preferable by clicking a button that says "save". Instead of having them type in the info from scratch, I would like them to be able to navigate thru the rows and pick one that is close to what they currently need to enter. They will then make some changes to the existing row ... but instead of updating the current row, it will save to a new row.

It really is a simple problem ... but due to a non-resolvable problem in my previous post, i am asking for advice on how best to design this. If you would like to see my current problem with the "old" solution, please see http://www.access-programmers.co.uk/forums/showthread.php?t=70390

but like I said, i just want advice from you experts on how this (what I thought would be very simple) application should be designed.

 

[ghudson]

I advise against what you want to do. You should create a new record and fill in certain fields from the previously current record into the new record. Search the forum for the key word "duplicate" and you should find something close to what you need. Add my user name "ghudson" to your search and you will find some previous threads with sample db's on a method that works for me.

Good luck!

 

[skiefer]

Hi ghudson,

Thanks for the input on this. I have made your changes to my plan and all is working so far.

Here's the tricky part though. I need to have the code check for a value in one of my screen textboxes and do the update accordingly. I have a checkbox that allows the user to enter a number from 1-10, if the user enters '1', only 1 row should be added to the db. If the user checks 5, 5 exaclty the same rows should be added.

(I know, i know, before I get the lecture, this is not good database practice), but let me briefly tell you why this is. These temporary table is built for the sole purpose of doing a report print of labels. Sometimes the customer needs more than one of the same label to be printed. I just put all the data in the table, then print the report.

Back to the question. Here is the loop that I used when I coded the insert in SQL:

For i = 1 To Forms!fmlabels!numlabels
DoCmd.GoToRecord , , acNewRec
MsgBox message
Next i

I know it's cycling thru the loop the correct number of times (my msgbox pops up), but it's not duplicating the record.

Any ideas on how to accomplish this?
thanks for the help!!
Steph

 

[ghudson]

I suggest that you add an "append" action to copy the record to your temp table.