Find customer record

[tigerstripes]

I have tried searching for this but don't seem to be able to find anything that actually relates.

I have a simple mailing list which has customer names & addresses and activities we will be mailing out about.

There is a form for customer details with a subform for the maillists they wish to be placed on.

What I am trying to do is place a button on the main form which will ask for first name and surname then move to that particular record, showing the subform records for that person.

I have a parameter query to ask for the first / last names but I'm not sure how to use this to filter the form. Does the query need to inlucde fields on the subformas well as the main form?

Or is there a completely different way of doing it?

I dont really want to use the access find / replace option as it is far too complicated for most of the end users.

Thanks in advance for your time and help.

 

[Alansidman]

Hey Tiger;
Take a look at this video for some good ideas on how to do it.

http://www.datapigtechnologies.com/flashfiles/buildcustomfilter.html

Alan

 

[tigerstripes]

Thanks for that Alan, looks like it is just what I need.

 

[Gannet]

Word of caution on the video. When requering the form it will look for all matches to the pattern created by "Like forms![frmName].[control] & "*""

If you have an autonumber for your index with numbers ranging from 1 to 110 and the combo box is looking for record 1 then you will get several results because several records will match the patter 1*.

If you were to look for 10 you would get these results:
10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109
since they all follow the patter 10*

 

[CEH]

I agree with Ganet. In fact I would not use the code on the video. It's pointless and confusing to any user. I guarantee you will have users asking why it returned multiple, unrelated records when they picked only one! Drop the "Like" and the "& "*" They serve no purpose. If they field it was searching was a text field...like company name...then it might be appropriate, "Smi" would return "Smith", "Smith & Co"... so on.... But here you are using a field that the user will probably never see. A simple reference to the record the user picked would be all that is needed. forms![frmName].[control]