Auto populate field based on entry in another field

[rpowers18]

I am trying to populate two fields based on another drop down field. I have amended some code downloaded from this site but am getting an syntax or paratheses error.



= SELECT([Oracle Codes].[GROUP], [Oracle Codes].[ID]) FROM ([Oracle Codes] WHERE([Oracle Codes].[DESCRIPTION])=([Forms]![Job Entry Form1]![Combo38]));

This is the code I downloaded:

SELECT[Suppleir Details].[DetailsId], [Suppleir Details].[Supplier Name] FROM [Suppleir Details] WHERE ((([Suppleir Details].[DetailsId])=[Forms]![Form1]![Combo0]));

A another note part of the download included this code: SELECT [Suppleir Details].[DetailsId], [Suppleir Details].[Supplier Code] FROM [Suppleir Details];

When I try the code in red above it returns the DetailsId in the combobox instead of the Supplier Code when it the example db it returns the Supplier Code.

Any assitance would be appreciated. It has been awhile since I worked in Access and it shows.

RGP

[ssanfu]

Welcome to the forum!


Set the column widths property to 0 (zero).
That will hide the [detailsID] column.
In Access2000, the column widths is on the Format Tab.

[June7]

Using a SELECT sql as an expression in ControlSource property won't work. Options:

1. Include the related table in form RecordSource, join type 'Include all records from {your primary table} ...', bind textboxes to the related fields and set them Locked Yes, Tab Stop No.

2. Make the combobox RowSource a query that is a join of the related tables and have textboxes reference columns of the combobox

3. DLookup() function in textbox