22 inch max form length, but can you get more form length if.....

[iowabuckmaster]

you use tab control and go to different pages. I have about 45" of form space I need, Multiple questions with mutliple radial button anwsers that are captured into text fields. Can't seem to find this info w/o actually doing it. Or what is the best way to get 45 inches of form space to get all this info into one record? Thanks for the help.

 

[SgtJarrow]

Create forms similar to what you find in a wizard.....the first form has the first group of questions, next form has the next group, and so one.....they call all me based on the same table or query, but only hsowing the revelant fields for that grouping...

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[iowabuckmaster]

Not sure what you mean by ....they call all me based on the same table or query, but only showing the revelant fields for that grouping...

It is set up now with a mainform and two subforms but when saved it saves to 3 different records. I need it to save to a single record for the table the forms are based off of. So I was hoping to pile everything into one form, hence my original question. Please advice. Thanks

 

[SgtJarrow]

Create a query that contains all the fields you want recorded. You must also include the ID field for the record. Create a form that is based on this query and contains the ID field and the first group of questions. Include a button that closes the current form and opens a new form, which also contains the ID field and the next group of questions. Make sure you have this second form based also on the query and open it to the same ID number as the first form. If you ned help with the open command, let me know. The third and subsequent forms are all then same as the secodn. When the last form is completed, a finish button will "save" all the data, which really has been saved all along, but to the user it "finalizes" the process...

If you are still lost, send a message to my work addy and I can send you an example.

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[iowabuckmaster]

Ok, I will look deeper into this. The 3 pages are on separate forms now. (mainform subform subform) I may need clarification of how it saves it all as one record. Or is it the idea that all three forms are open and tied to the Id field that will save it to one record? I hope I can change the control source to a the new query. rather then recreate forms scratch. I will have to pick up Wed as I am out for rest of day and tomorrow. Thanks for all help.

 

[SgtJarrow]

yes...having each form subsequent form after the first open to the same ID number will ensure all data goes to the same record...please let me (us) know what questions you have to open the forms appropriately.

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[iowabuckmaster]

mstrmage1768, Thanks for the help. I finally got back to this. I first tried to put all the questions and radial buttons on the tab cntl Page 1, 2 and 3. I hit the control limit for the life of the form. So on your advice I just had 3 forms closed and open forms based on the unique ID field. Here what I basically used. I only had one table so I didn't have to create a query. Thanks again.


Dim stDocName1 As String
Dim stDocName2 As String
Dim stLinkCriteria As String
Dim strIDvariable As String

stDocName1 = "add page1"
stDocName2 = "add page2"

strIDvariable = Me!ID

stLinkCriteria = "[ID]=" & strIDvariable

DoCmd.Close acForm, stDocName1

DoCmd.OpenForm stDocName2, , , stLinkCriteria