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!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

combo box 1

Status
Not open for further replies.
tizwaz

tizwaz

Technical User
Aug 8, 2002
437
GB
I have 2 fields FileRef and RelatedFileRef and want to have a search form with a combo box which will include all the entries in both fields. Is there a way of doing this?
 
Sort by date Sort by votes
Use a union query...

SELECT FileRef FROM Table1
UNION
SELECT RelatedFileRef FROM Table1
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rony01
  • Locked
  • Question
Dependent combo box in sub form
Replies
1
Views
140
dhookom
dhookom
PL01
  • Locked
  • Question
How to set combo box to specific value
Replies
2
Views
133
PL01
PL01
jmc014
  • Locked
  • Question
Combo with multiple colums/duplicate data 1
Replies
3
Views
121
PWise
PWise
jmc014
  • Locked
  • Question
Remove the first line form a Memo box 1
Replies
4
Views
163
jmc014
jmc014
BradCustom
  • Locked
  • Question
Store Text Box data in a Table Field
Replies
5
Views
114
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top