Re: Limit field choices based on another field

From: Allen Browne (AllenBrowne_at_SeeSig.Invalid)
Date: 10/29/04 

Date: Fri, 29 Oct 2004 23:00:26 +0800

I'm not making sense of the SQL statement.

The middle field will end up being something like:
    (99) ProductName
and I can't see that being a valid field name. 

-- 
Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"grep" <grep@grep.com> wrote in message
news:eR$gnRcvEHA.3916@TK2MSFTNGP10.phx.gbl...
> Allen,
>
> The examples provided are helpful, but I've found something that makes no 
> sense to me.
>
> I now have Model's control source as the table's Model field. I have also 
> created the stored query:
>
> SELECT ProductID, "(" & PartNum & ") " ProductName AS Product, MakeID FROM 
> ProductsTable WHERE MakeID = Forms!PurchaseOrders!PO_Details!Make;
>
> When I run the query with the form open and the appropriate selection in 
> the Make field, it shows the appropriate options. When I set this stored 
> query as the Row Source, however, I see nothing in the Model field, even 
> after a requery.
>
> I have set the number of columns as 3 with column widths of 0";3";0" and 
> the bound column of 1. This *should* show me the correct info. Something's 
> wrong and I'm not sure how to troubleshoot it.
>
> Any suggestions?
>
> grep
>
> Allen Browne wrote:
>
>> See:
>>     Limit content of combo/list boxes
>> at:
>>     http://www.mvps.org/access/forms/frm0028.htm
>>

Relevant Pages

  • Re: subform issue
    ... tblOrders - in the table itself, not a combobox control in a form - then i'd ... Design view, go to the city code field, click the Lookup tab in Field ... ProductName FROM tblProducts ORDER BY ProductName; ... The subform is bound to a query based on Orders and Order ...
    (microsoft.public.access.tablesdbdesign)
  • Re: displaying additional data that correlates to my query
    ... One approach would be to take the result of your GROUP BY query and do an ... the same ProductName have the same minimum TargetDifference. ... SELECT [Flux Density Query].ProductName,MIN([Flux Density ...
    (microsoft.public.access.queries)
  • displaying additional data that correlates to my query
    ... ProductName, Voltage, Current, Peak, TargetDifference ... I have created an additional query to retrieve the Peak that is closest to ...
    (microsoft.public.access.queries)
  • RE: QUERY DESIGN HELP
    ... which custId, productName, categoryName the customer wants to be listed under. ... At the moment I have a query that pulls all this info together. ...
    (microsoft.public.access.queries)
  • Re: Criteria & Joins in Queries
    ... Yes, you are making sense, I think I understand what the problem is. ... One workaround is to make a query on the right table and impose the criteria ... for excluding expired data there, then use that query rather than the ...
    (microsoft.public.access.queries)