Search results

alright so I think I figured it out, set a field as UNIQUE I need to set up my relationship then I can add a fields from two different tables to my query Currently there is no drop down box though, for rarity. I am only allowed to enter values from the rarity table, but I'd like to be able to...

I am trying to use the multiple items form and I am not sure if that is what I should be using. I'd like to add a new purchase with a form. The purchase would include multiple cards. I have a card table and would like to select from that. Currently I have the cards listed in my purchase query as...

I am having a similar problem, trying to understand the example you posted of why not to use lookups in tables. In tblStock Query, I tried sorting each row, seems to work to me..am I missing something?

I suppose I should just auto attach a file from now on ;) I only have access 2010 sorry Thanks for responding. whats up with no backwards compatibility MS? grr

So I've read that using the lookup wizard is a bad idea in the table view so I am wondering what I should do instead Basically I have a a table "CardList", I'd like to be able to add a new purchase to my Purchases table where I would select the card from those in "CardList" from a drop down box.

Wonderful script :) Is there a way to search multiple fields at the same time? for instance: name location john localA and I could search john (space?) localA? I tried the updated code and that did not show up With the data I uploaded, you can try entering in Ball Bearing then space...

My problem is very simple, I want to filter data based on user input in a combo box. Looking for (Set) : ["selected":dropdown box of different sets] Then I am not sure where to go from here, I thought I should put a subform, but displaying the filtered query would work as well. I already...

Thank you very much

I attempted to follow john big booty's dynamic multi search No errors, I followed the directions exactly..(or so I thought, several times) and nothing happens when I enter search data. Thanks for any help