trying to query from a list box to a text box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am having a difficult time trying to write a query that will display
different outputs depending on what is listing in the text box. For example
I have a table that lists hundreds of platter logs and I am trying to write a
query that will give me the tranlog for each platter log I request. I am
able to write a query that will give me one response (platter log to
corresponding tranlog) but I am unable to change the text box then have the
list box correspond with the correct response. Please help. Here is my
query that has been written so far in the list box

SELECT DocFamily.Tranlogs, DocFamily.Interleave, DocFamily.[Media Size] FROM
DocFamily WHERE DocFamily.[family name]=[Combo20];
 
Try to write the full path of the field

SELECT DocFamily.Tranlogs, DocFamily.Interleave, DocFamily.[Media Size] FROM
DocFamily WHERE DocFamily.[family name]=Forms![FormName].[FieldName]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking to update fields 1
Query with results in a value list from a combo box? 1
showing just the latest value in a text box 3
Query and List Box 1
List boxes, functions and query criteria 9
List box instead of a text box in a parameter query 1
Using a list box inside a query 3
Running a query on items selected from a list box. 4

Back
Top