Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Join multiple fields in a form
Thank you, SeeThru & PHV. I was trying to go straight from my table to a form, & that was giving me some problems. However, now I'm making the combination in a query (as you suggested), & then I've based my form on that query (instead of the initial table). This works very well for what I...- iamerm
- Post #11
- Forum: Microsoft: Access Other topics
-
Join multiple fields in a form
Thanks for your reply, SeeThru. Is there a way to populate a field in a table in the same manner that you just described in reference to a form? (Using the =[Part1] & "-" & [Part2] & "-" & [Part3] method) For example, if I have a table with the following fields: ref (autonumber) PartX...- iamerm
- Post #8
- Forum: Microsoft: Access Other topics
-
Join multiple fields in a form
I'm new to the forums, so I'd like to thank everyone in advance for your useful tips. I have a question regarding the method you just described: I'm trying to create a form that will generate part numbers based on certain criteria. For example, I'd like a part number comprised of 3 segements...- iamerm
- Post #6
- Forum: Microsoft: Access Other topics
