Is having two instances of the same fields on a form ok?

[amy3000]

I have an Access form that's being filled in from a paper form. The paper form has changed in the last year so there are some common and some not common questions between the two. We're still entering both kinds into one table. I know there's probably a way to have certain questions appear depending on which form is being entered.

However, I probably won't be able to figure that out with my limited coding ability. What I thought I would do is just copy and paste the questions a second time, and set up the second set to follow the order of the second version of the form. I tested this and it appears to work ok. The table it's going into has the correct data. I'm just wondering if there may be some unanticipated consequences.
Thanks as always, Amy

 

[AvGuy]

Your question is too general to elicit much response. If you have a specific question about a specific topic then I'm sure someone can help you.

AvGuy

 

[JeremyNYC]

There's nothing that will break if you have multiple controls on a form bound to one field in the datasource (at least, nothing I know about).

I do think it would be better, though, to have two forms, if what you're doing is mimicing the layout of the paper form. Just have the user open the form that mimics the report he or she is copying from.

Jeremy

==
Jeremy Wallace
AlphaBet City Dataworks

http://www.ABCDataworks.com

Access Databases for Non-Profit Organizations

Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.

 

[amy3000]

Thanks, I could do another form too. And now I know the right vocabulary too for describing this.