Field list

[Richard]

I have a combo box set to field list. My row source is SELECT
tblPurchData.PurchaseOrder, tblPurchData.StoresOrder, tblPurchData.MemoNumber
FROM tblPurchData; I was wondering if it was possible to display my field
list in a different way. Right now the drop down list look like this
PurchaseOrder, StoresOrder and MemoNumber id like it to look like this
Purchase Order, Stores Order and Memo Number so it makes more sence to the
user.
Thanks for your help.
Richard

 

[KARL DEWEY]

Try this --
SELECT
tblPurchData.PurchaseOrder AS [Purchase Order], tblPurchData.StoresOrder AS
[Stores Order], tblPurchData.MemoNumber AS [Memo Number]
FROM tblPurchData;

 

[Richard]

Hi Karl

That looks better...but it opens a parameter box I use this combo with a
unbound text box for searching these 3 fields.

Try this --
SELECT
tblPurchData.PurchaseOrder AS [Purchase Order], tblPurchData.StoresOrder AS
[Stores Order], tblPurchData.MemoNumber AS [Memo Number]
FROM tblPurchData;

--
KARL DEWEY
Build a little - Test a little

I have a combo box set to field list. My row source is SELECT
tblPurchData.PurchaseOrder, tblPurchData.StoresOrder, tblPurchData.MemoNumber
FROM tblPurchData; I was wondering if it was possible to display my field
list in a different way. Right now the drop down list look like this
PurchaseOrder, StoresOrder and MemoNumber id like it to look like this
Purchase Order, Stores Order and Memo Number so it makes more sence to the
user.
Thanks for your help.
Richard

 

[KARL DEWEY]

Sorry I can not help. I have never use Field List and thought you had made a
typo in the post.
--
KARL DEWEY
Build a little - Test a little

Hi Karl

That looks better...but it opens a parameter box I use this combo with a
unbound text box for searching these 3 fields.

Try this --
SELECT
tblPurchData.PurchaseOrder AS [Purchase Order], tblPurchData.StoresOrder AS
[Stores Order], tblPurchData.MemoNumber AS [Memo Number]
FROM tblPurchData;

--
KARL DEWEY
Build a little - Test a little

I have a combo box set to field list. My row source is SELECT
tblPurchData.PurchaseOrder, tblPurchData.StoresOrder, tblPurchData.MemoNumber
FROM tblPurchData; I was wondering if it was possible to display my field
list in a different way. Right now the drop down list look like this
PurchaseOrder, StoresOrder and MemoNumber id like it to look like this
Purchase Order, Stores Order and Memo Number so it makes more sence to the
user.
Thanks for your help.
Richard