Macro Search Button

Discussion in 'Access Macros' started by tashey, Jun 1, 2010.

  1. tashey

    tashey Guest

    I have one main table and two tables connected to it with 1 to many
    relations. I have created a search button and macro is used using SetTemVar
    and wildcart operator "like" to specifically give me the data that I put in
    the search text box (search button on its right). I am able to query the
    field from the main table, but when I do that for fields in other two
    connected tables, no record is displayed. There is no error message either.

    Please help me in this regard.

    Thank you very much in advance.
     
    tashey, Jun 1, 2010
    #1
    1. Advertisements

  2. tashey

    KARL DEWEY Guest

    I am able to query the field from the main table,
    How are you able to 'query a field from a table?'
     
    KARL DEWEY, Jun 1, 2010
    #2
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.