search form which returns forms

[sailock]

hello everyone, i am new in access and i need your help.

I have a db with 20 tables and for each table i have create a form.

In every table i have 2 same fields , lnumber and st.date.

The search form i want to create must have these 2 fields for search and when i complete those i want to return me the forms with those parametres.

There can be 2 a111 lnumbers but they have different st.date.

For example , i open a search form , i type in the first box a111 and in the second one i want a drop down menu with the st.dates that a111 has.
Then i choose a date .
After i press search and i want to show me all 20 forms with lnumber a111 and st.date the one i choose .
Then i press the form i want and watch and have the option to go back and choose a different one.

sorry for my english , for any specification ask me.

Thank you

[Seth Schrock]

What is the difference between all 20 tables? They sound very denormalized. If I'm right, then you would greatly benefit from normalizing your tables. See Database Normalization for more information on that.

Otherwise, you would have to join all the tables together using a UNION query. This would not be a good idea.

[sailock]

the tables represent documents and i formed them like the original documents.
every document has lnumber , st.date , and other varius informetions.
i dont know if that helped because i couldnt understand very well your link about my db but its very helpfull cause i just started to use access ty

[Seth Schrock]

Okay, it is as I guessed. What you should have it one table that has three fields: lnumber, stdate, and Document. The Document field would be the divider between the documents instead of having separate tables. Then your problem becomes very simple to solve.

[sailock]

can u help me with that ?
i can create a example of my db to upload , with 4-5 tables-formes to show u how i have done it

[zmbd]

sailock
Hello there... although we'll really walk thru the fire to lend a helping hand there is a certain level of foundational understanding that you require in order to get the most out of our help.
To that end, and the request of Seth, I've sent you a copy of my "boiler-plate" providing a set of links to not only the basic tutorials you need now, but also to a series of tools that will make your life easier in the future.
Please work thru the tutorials.
If you are still having issues after you master them, please come back here and we'll get out the big hammer and smash the problem to bits

BOL
Z (^_^)

[sailock]

this is a fast example about my db.

ty very much , i will read them i have plans about access, but i need ur help because i have a deadline .

[zmbd]

1) We can help you with specific question, we cannot build your project

2) You really need to have the basics as I've sent you. You simply will "get nothing out of"/understand our help because you will not have the knowledge base to understand nor implement the advice.

3) Please understand, many of us cannot or will not d/l un-requested attachments. This has absolutely nothing to do with who you are... In my case, such d/l are prohibited by my ITSec staff. For many others, it is part of "safe computing/best practices" not to d/l such files. A practical example as to why can be found here http://bytes.com/topic/access/answer...l-ms-products. this unfortunate Member opened a file from a trusted source and is now having all sorts of issues!

[sailock]

can u explain abou the document field u said earlier .
all i want is some help to create serch form with 2 criteria which returns some forms .
is there any example ?

[zmbd]

sailock<> is there any example ?

Work thru the tutorial I sent you (check your bytes.com inbox). There is an example to what you need to do therein.
We simply do not have the resources to teach you the fundamentals you appear to need…

[sailock]

ty for ur time :)