Designing a form in the Find-and-View-only mode

M

Mishanya

I have tblPackages:
1) PackageID - unuque index
2) ClientID (cbo with ClientID and ClientName based on tblCLients )
3) ProductID (cbo with ProductID and ProductName based on tblProducts)
4-14) A few fields with package-related info.

The table determines how the clients want the product to be packed for
delivery.
Every client may have predisigned package for each product or for just a few
of them. I.e. if there are 10 clients and 10 products, then there are up to
100 package IDs (up to 10 for every client).

I want to create a form with cboClients ,cboProducts and all the
package-info (items 4-14 from the tblPackages), where first I choose a
ClientName from cboClients (wich filters cboProducts down to the list of
products the client has predisigned package for), then I choose a ProductName
- and all the package-info is presented.

So far I can create a form for inputting the data in the tblPackages and
then view the records by paging. But I need to have a form with comfortable
approach directly to the wanted package with only view option (no adding or
changing data).

I've already learned how to filter one Combo based on other.
Please help with designing this kind of form.
 

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

Ask a Question

Top