Working with many forms

[rsfnoam]

Hi there
Sorry for not writing for couple of weeks..a lot of work ...
Well sometimes simple things become complicated problems.
This is the problem i got..
I am working on a db which manages callers to the clinic..
I work with one table (callerstables)and 4 forms(Generaldetails,callerid,callerrec,Eventdetail)
on the Search form Button that i created on Generaldetails form I want that all my forms will be opened and that it will automatticaly jump to the Generaldetails . How do I set focus to the generaldetails?
Stupid aint that? but that's the problem I got..
Thanx alot in advance for some help
Noam

 

[Trevor G]

May I ask if you are wanting to see a particular record based on all the 4 forms? If so then from the main form open in design view and then drag your other forms into it, you would then check the relationships for each subform to make sure the Mastser and Child fields match. If the forms are rather large in detail or fairly small consider using Tab Controls and placing the subforms into each tab, change the caption of the tabs to something useful and you have a controlled form.