Form/SubForm Search problem

  • Thread starter Thread starter Philo Hamel via AccessMonster.com
  • Start date Start date
P

Philo Hamel via AccessMonster.com

I'm new to Access Monster, so first I like to say "HI!" to everybody. I've
been here a lot lately (since I started working on this database for my
employer), but didn't register yet. I'm a complete noob at Access, so
please be patient :)

Here we go...
I'm working on a database similar to the Northwinds sample one. I've made a
table for the Products (tblProducts), one for the Customers (tblCustomers)
etc. Now I want to create a form like the Order form from the sample (with
a subform), but with a difference. When selecting a product in the subform
you?ll need to find the product first. To find a specific product you will
have to do a search within the table tblProducts, which has descriptions of
all the products (the descriptions are not the primary key) . Example:
when doing a search for ?Scan? you?ll need to find:
- scan digital A4
- repro scan
- hardware scanner

(This could all happen in some kind of search form, I don?t know.) From the
results a choice is made, and the result ends up in the subform of the
orderform.

So please help me out, how do I make this work and is this the right way to
go?

Thanks,
Philo
 
From what I can tell, it appears that you want to be able to retrieve
multiple records based on a search, as in your example of "scan". Take a
look at the
"Like" function; it most likely could be used to get your desired results.
 
Hey darrep,
Thanks for the reply. I already looked into the 'Like' function and it
looks like it's one. But how do I mix this with the form / subform setup. I
don't know much about VB and the things I've setup already don't work.

I need a way to activate a search form that, after searching, returns the
productID to the subform. This ritual has to work everytime you want to add
another product to the order.

Hope somebody knows a way...
 
Back
Top