Field list

R

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
 
K

KARL DEWEY

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

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.

KARL DEWEY said:
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


Richard said:
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
Click to expand...
Click to expand...
 
K

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


Richard said:
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.

KARL DEWEY said:
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


Richard said:
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
Click to expand...
Click to expand...
Click to expand...
 
Top