Need a little help

[rkana]

I have been reading and searching for all I have been trying to do with my database but I do not know how to really search for this one or if it can be done.

i have a bunch of applications to which i transfer data from 1 form to another. i use a combo box to find the record which then displays the rest of the information i need on the form. thats ok but it does take a while and i usually print out 200-300 applications a month so i wanted to know if the below is possible-

problem1
if i have forms called form1,form2,form3(i actually 46 forms with 200-300 people to choose from) and form4 has the information that goes into the other forms and i have a combo box on the name of the person to fill in the rest of the fields on say form1 but i have to scroll through to find who i want. what i would like to do is have a button or something that i can use on form4 automatically pulls up form1 based on them entering that they wanted form1.

problem2
also i dont know how to do this, of the 200-300 people i have there are actually 800 records because i dont know how to put the forms they want is there a way to have form4 and a new line for another form and if possible have the same button as in problem 1.

 

[Calvin]

If I followed your message right, you should be able to do what you want but I can't envision where to start, can you export the four forms and some related data to another mdb and zip it up and upload it?

 

[rkana]

ok heres a sample i made it as simple as i thought i could and still get my question across

if not, let me know

 

[rkana]

ok i been doing more reading and searching on here and i got mostly what i wanted my db to do(it dont look pretty but it does the trick)
now heres a question maybe you can answer(i have looked for it but if i found i didnt understand it.
how can I
a)make a sub form show all records like datasheet without changing it to a datasheet(because I want to keep the same background on both forms)
or
b) make a form that puts all the records related to the field on different rows. what i found was to put in on a main form text box control source

=subform sheet2![medicine] and i will attemp to hide the subform or

=Sheet2!MEDICINE

and i did this for the other fields that i wanted to see but want i want is to see more than 1 record at the same time)
kinda like ptname and its demographics is 1 form and that medication and how much and how it is taken on another form. mostly all of them how more than 1 medicine

also it would be cool if i could make a msg appear telling me it is time to reorder medicine for that patient. basically i have an order date, a receive date and a reorder date, most of the way i order meds varies according to what they are taking, some are 45 days, some 60 days and soforth and so on.

thanks for reading and taking the time to help.

 

[rkana]

man aight i got some more work done, what i needed to do was make the subform in tabular and boom and then with more searching i fishined it all maybe a touch up here and there but Thanks to all the forums and the people who provided the knowledge

any tips on the message box for the reorder?