Continuous form

[gawai]

hi,
i have issue with continuous form, there are 2 rows(records) matching name but form showing only 1 -last record.
below screen for ref.


any idea ?

 

[gawai]

It is a little difficult to figure without having access to your Form to see exactly how it is designed, but in looking at the VBA code, it looks like you are looping through your records to the last one, so I think that would only return the last record:

[COLOR=#333333]rs.MoveNext[/COLOR]
[COLOR=#333333]Next foundRec[/COLOR]

i tried with do while loop. but still same.

here is the (form). pls have a look. the (table) is not in the same file.

Remote.rar

 

[Joe4]

I downloaded your database, but it looks like it is trying to access another Access database as its data source, and that wasn't included in your zip file. So it tosses out errors.

In any event, I am not sure why you are using Recordsets, when it seems like a simple Parameter Query, Filtered Query, or Search Form/Query will do.
Can you explain why you have elected to use this method?

Also, I am not sure why you have an Access database that only has a query in it. Why wouldn't that be part of your other database?
Also, if you do need it in its own database for some reason, why not use a linked Access table to the other database instead of trying to read the data in like you are via a Recordset?

 

[gawai]

the database file will be in server as storage.
This file will be accessing the database remotely by multiple users.