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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to select values from two columns in one field?
Yes, all 3 are the same data type (text),and my form in this moment works fine when they are separated, but in the subform fields became too much and I wanted to at least one removed (barcode), and I always wondered how I could do this (pure curiosity). Here are some more clarification on the...- drsayman
- Post #3
- Forum: Microsoft: Access Forms
-
How to select values from two columns in one field?
Hello, I have a form (Orders) with a subform (OrderDetails) that have a fields like a Barcode(from tblBarcode), ProductID(tblProducts), ProductName(tblProducts) and etc. I want to union Barcode and ProductID fields into one where I can type ProductID.Value or Barcode.Value(if have Barcode) and...- drsayman
- Thread
- Replies: 2
- Forum: Microsoft: Access Forms
