Search Records

A

aiman

Hi,

need help from u guys,

i'm new with access03, i created database which contain table Patient, Case,
SurgeryDetails.
i''ve created relationship between this tables where Patient is the one-side,
Case on the many-side, & SurgeryDetails is the many-side for Case. i also
created form with subforms.

How do i created a form where i can search records for Patient, and from
there i can view the Case & SurgeryDetails for the Patient & add data by
using the form??
 
O

OldGuy

I'm pretty new myself, but try opening your form in design view and click the
Combo Box Button on the tool box bar. a wizard will open and one of the
options is "Find a Record on my Form Based on the Value I selected". Hope it
helps.
 
A

aiman via AccessMonster.com

thank's for your advise..

but what i'm trying to do is to find a record based on value i type, then it
will search the database & display it if it is available.
Let say i type Patient name, it will search for the patient & display the
data. there i can add new data Case for the same Patient.

i've read about using the macro's & parameter queries... & still try to
figure it out what i'm doing wrong..

any advise would be appreciated..
tq..
 
Top