Newbie2012
Donna H
- Local time
- Tomorrow, 06:51
- Joined
- Jun 28, 2012
- Messages
- 33
I've created a query pulling fields from about 5 tables.
My form sources from 1 table which in a lookup about way, links to the 5 tables also.
I created the query because I wanted to concatenate various fields as a string from selected tables but use it as a combo box lookup (or find record).
(Some of the tables use different combinations of many to many...sounds like a mess but was the only way I knew how to make it work)
I've got the combo box showing the 5 texts together as a string, but am unable to select anything from it (with the windows ding sound)
Can someone guide me to the right fix please?
My form sources from 1 table which in a lookup about way, links to the 5 tables also.
I created the query because I wanted to concatenate various fields as a string from selected tables but use it as a combo box lookup (or find record).
(Some of the tables use different combinations of many to many...sounds like a mess but was the only way I knew how to make it work)
I've got the combo box showing the 5 texts together as a string, but am unable to select anything from it (with the windows ding sound)
Can someone guide me to the right fix please?
