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!
-
Possible to display more than one column's data in a lookup field?
Thank you, Remou! That works perfectly! You have just made a couple hundred people very happy. Otto- ottonomy
- Post #5
- Forum: Microsoft: Access Forms
-
How to position Form ?
MS Access 2.0 was compatible with Windows 3.0 (16 bit) from 1993 or so. MS Office 95 (and Access 95) were 32 bit and written to go along with Windows 95. Since Microsoft keeps some of its knowledgebase articles around forever, it's easy to find a bit of something like this that seems applicable...- ottonomy
- Post #6
- Forum: Microsoft: Access Forms
-
Possible to display more than one column's data in a lookup field?
This is what my row source looks like (This is in the design-view GUI of Access 2007, the Lookup tab of Field Properties. Is there another way of viewing it that will make the syntax look more like yours?): SELECT [People].[Person], [People].[LastName], [People].[FirstName]...- ottonomy
- Post #3
- Forum: Microsoft: Access Forms
-
Access 2007 windows only, no ribbons, etc
Hi Chris, Try changing the file extension of the database from .accdb to .accdr Hope this does what you want. Otto- ottonomy
- Post #2
- Forum: Microsoft: Access Other topics
-
Possible to display more than one column's data in a lookup field?
I am editing an Access 2007 database created by someone else. One of the forms has a lookup field which pulls data from four columns of a parent table. The bound column is a numeric ID value, and the others are "last name", "first name", and "business name". Not all of the records in the parent...- ottonomy
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
