Continuous Form with Add New Record Command Button

[chrisrigoni]

I am trying to make a form with 4 text boxes for entry. I want to have the first text box be filled from a reference to a field in a table. The rest, I want the user to fill out the information. Also, I want a button at the bottom of the form to add a new record and fill the first text box again with the same value as the first and then the user fill out the other three. I want the user to be able to do this repeatedly as many times as necessary with the same thing happening everytime. Then, when finished adding the needed records, I want them to click another command button on the right side at the bottom of the form and be able to submit the data to a table that has been created. I thought about using "append query" to do this. But, to be honest, I'm lost on how to start on any of it. I can do the form and textboxes, but making the button for adding another record and the rest, I don't know. I also want it to be a continuous list so that the user can see each record on the form as they enter it and the previous records they have entered before they submit the data to the final table. Help please?

 

[ajetrumpet]

first of all, this is unorthodox. but it can be done.

it sounds like you want to create a table for all the records when you are done filling in the data. i believe though, that a form has to be bound first before you can create a C form to do what you want.

take a look at the "cycle" property on forms to determine what you need here also. you will need "all records" I think, but I remember correctly, I don't think you can use a button to create a new record on a C form unless you couple it with code. I think it's either, see the new blank rec at the bottom of the form, or don't see it. but I could be wrong.

a picture of what you want would help others see this too...

 

[chrisrigoni]

I tried to get a picture up, but didn't have any luck. So, here is basically what I am trying to do:

Text Box 1 Text Box 2 Text Box 3 Text Box 4

Text Box 1a Text Box 2a Text Box 3a Text Box 4a






Add New Record Button Submit Button


The "a" text boxes would appear when the user clicked the "Add New Record" button. The initial text boxes would stay with the data entered. And the user could do this as many times as necessary, then submit with the "Submit" button and then the data would populate the table.

 

[ajetrumpet]

I tried to get a picture up, but didn't have any luck. So, here is basically what I am trying to do:

Text Box 1 Text Box 2 Text Box 3 Text Box 4

Text Box 1a Text Box 2a Text Box 3a Text Box 4a






Add New Record Button Submit Button


The "a" text boxes would appear when the user clicked the "Add New Record" button. The initial text boxes would stay with the data entered. And the user could do this as many times as necessary, then submit with the "Submit" button and then the data would populate the table.

i would consider doing this another way chris. what you want will involve lots of unneccessary code (in this man's opinion).

if you don't want the blank record to appear on the bottom of the C form, you will need to set the allow additions prop to FALSE. then change it when you want to add a new record. as i said before, i think this is unneccessary. btw, to upload a picture, wrap it with the IMG tags, e.g. - [ img ] and [ /img ]. link it to a photobucket or something. uploading a database instructions can be found in the GENERAL section of this site I believe. Larson has given instructions on how to do it.