advance search record

[miziri]

Hi,
i want to make search on first_name and second_name ?
in form i have two fileds ,firstname. second name,i will enter into both fileds ,
if that names are found before will gvie warning box you want to see Yes/No display all related info in database with main form and subform .
my database structure is:-
main form with first and second name,sub form with date_visit and descption.

note:-this part of my question
this my problem still no body solve it

thx

[Robeen]

- Your Tables & Forms go Right to Left. I've never seen that in Access!

There's no data in your Database that you attached.

I would:

Table1:
PersonID: Integer [Not AutoNumber like you have].
Fname: Text, 25.
LName: Text, 25.

Table2:
PersonID: Integer [Same as PersonID in Table1].
VisitDate: Date.
Description: Text, 255 [or shorter].

If a PersonID can have more than one Visit - then make your subForm into a Datasheet so that all Visits will show up for each PersonID.

You can try making your Main Form a Search Form based on values in Table 1 with ComboBoxes for cmbPersonID, cmbFName & cmbLName.

When a person selects a PersonID from the PersonID ComboBox and clicks a 'Search' Button [for example], you can open the Sub Form with code like this in the Click event for the Search Button:

 
DoCmd.OpenForm "SubForm", , , "PersonID = " & Me.cmbPersonID

When a person selects a FName from the FName ComboBox and clicks the 'Search' Button, you can open the Sub Form with code like this in the Click event for the Search Button:

 
DoCmd.OpenForm "SecondFormName", , , "FieldName = '" & Me.cmbFName & "'"

OR:
You can link your Main Form to your Sub Form using PersonID as the Link field. Make the Sub Form a Child Form of Main Form.
Then, when you select a PerosnID from your Main Form, the Sub Form will show all visits for that PersonID on the Sub Form.

Here's a link to a page that will help you with this project of yours:
http://office.microsoft.com/en-us/ac...010098674.aspx

I hope this helps!

[miziri]

Hi,
friend i put some info see attched file
plz put ur code on it


thanks

[Robeen]

You should try doing it yourself. It will take longer, but that's how you learn.



All the best! Let us know if you run into problems after you try for yourself.

[miziri]

Hi,
I will try that code,if i fail i will ask for ur help

thx