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]
 
Back
Top