I can not seem to display all the records in the page that matches the search.

Hi,

What was your search, exactly. I ran the search based on street = Main and "any part" and got 3 records, which is correct.


Ken

the search I did is the same and it does return the records, however the three records does not dipaly in the results form at the sametime.. you have to select one at a time in the reluts form..

TonyEF,

If I understand you correctly, you want to see all the records in the result form one after another, you will need to make it a continous form not single.


Hope this helps


Ken

TonyEF,

Take a look at the form in here and let me know if this is what you wanted.


Ken


SRTS--3-.zip

I try that and when I change it to continous all the record from the table display... if you change it and search for the street name of "Saint" you will notice that all the records displays and I only have one records that matches the search..

It still not working.. Like I mention about, if you search for "Saint" for the street name you will see that the resutls forms displays the other records as well...

try this one


SRTS--2-.accdb

capricorn1
its not working, if you search by streetname and enter "Saint", no results come up, however there is one record in the table and when you search for "main", finds the three records but does not displays them all in the results page..

because, that  record is not part of records returned by the query that you created as the record source of the form.

try changing the record source of the form to tblMainInfo

TonyEF,

capricorn1 is correct, the result form is based on the relationship with the attachement table and only the records that have the matching id's. Your are using the main table id for the attachment and the id for the tblmaininfo.


Ken

sorry,

If you remove the attachment table from the forms source, the search form works. There is no main table if in the attachement table for the streetname like "Saint".


Ken

I understand, but I need to have that other table to display the data associated to both records. But I added an associated record to the other table and the record come up, but when you search for main only one record is displayed and I want to have all the records displayed in the results form.

If the results are correct then make the result form Continous to view all of the detail records and make the form larger.

Ken

TonyEF,
 i don't mind splitting the points with somebody, but not in this case,
i gave you all the working solution.
you split the points to a comment that was just a repetition of what i posted.

In this case I agree, even though I gave the continuous form part up front, I was too late posting on the important part.

no idea how to rectify the issue Capricorn1 and my apologies..

click on Request Attention above and ask to reopen the thread.

my apologies for the confusion...