look up help (1 Viewer)

[Esther Avery]

Can anyone help me with a look up - I need to show two columns but I can only see the first one in my table, although two show when I go to the drop down!

 

[Severin]

It only shows the first column that's not 0 in width. There's different solutions to that. I have made a db with examples of various uses of comboboxes.

Check out the download section!~)

 

[Esther Avery]

Thanks - I looked at the combo boxes and I can see the correct example but I can't see how you showed two columns - I don't know where to change it in the Lookup field properties!?

 

[Severin]

When you click on the combobox in question all relevant code is showed in the box on the right!~)

The trick to that specific combo is to have a field in your query that combines the 2 columns. Then you set the column width to a very small number. Access doesn't show columns in the dropdown if they are to "thin" but if it's the first column that's not 0 then it will be used to fill the textfield.

 

[Esther Avery]

Thanks - I worked out how to see the field properties after I had sent the post! I still cant get it to display both fields -I am building a new table, not a query, I have tried changing the widths but it doesn't change what I can see!?

 

[Esther Avery]

I am using a table/query row source type SELECT [Food Fact Sheets].[Title], [Food Fact Sheets].[Next review due] FROM [Food Fact Sheets]; Bound Column 2 column count 2

 

[Severin]

SELECT [Food Fact Sheets].[Title] & " " & [Food Fact Sheets].[Next review due] as NewColumn, [Food Fact Sheets].[Title], [Food Fact Sheets].[Next review due] FROM [Food Fact Sheets]; Bound Column 3 column count 3 and column widths: 0.01;2;2

 

[Esther Avery]

I think I am nearly there

I have put SELECT NewColumn, [Food Fact Sheets].[Title], [Food Fact Sheets].[Next review due] FROM [Food Fact Sheets];

is that right?

It is now asking me for parameter value for Newcolumn - is that &""&?

I wasn't sure about this part:

SELECT [Food Fact Sheets].[Title] & " " & [Food Fact Sheets].[Next review due]

I am desperate to sort this today so thanks for all of your help!

 

[Severin]

This should be right:

SELECT [Food Fact Sheets].[Title] & " " & [Food Fact Sheets].[Next review due] as NewColumn, [Food Fact Sheets].[Title], [Food Fact Sheets].[Next review due] FROM [Food Fact Sheets];

 

[Esther Avery]

thanks so much - it worked!!! Can't thank you enough
Esther