Match Equivalent in VBA

[jibb]

Hello,

I have got a combo box with a product code in it, and depending on which code is selected I want the data to come from one of two different tables. Is there any way I can do something like a match formula in Excel to see if the stock code is contained in a table?

Any ideas would be good!

Thanks

 

[namliam]

In this case probably a DCount function is the best thing... Though one has to wonder about the design with this type of thing.

 

[jibb]

Perfect, thanks.
There is a perfectly good reason for the design of my form but it would be a little complicated to explain!

Thanks for your help.

 

[David R]

There is a perfectly good reason for the design of my form...

There always is.