Movefirst in Subform

Prince

Registered User.
Local time
Today, 12:16
Joined
Oct 2, 2003
Messages
29
Happy New Year...
In one form of my system I added subform to diplay the data of search fields in the main form and this subform has nivgation buttons.
If I nevgate using the the nevigation buttons then I made another search, the subform diplays data starting from the same position where I stoped nevigation before the search and not starting from the first record that match my search criteria?

I think the solution to use Movefirst for the subform from the main form but I tried

Forms!SInquiry1!SInquiry2.MoveFirst
it didn't work(SInquiry1 = mainform, SInquiry2= subform)

also I used
Forms!SInquiry1!SInquiry2.GoToRecord , , acFirst

and it didn't work

anyone can help?
 
I made the data source of the subform a query searchs for data that matches the data of search fields in the main.
I first made the subform with nivagation buttons then I drag it to the main form.
 
Prince,

I think you just have to Requery the form.

Wayne
 
I actually did the following:

I made several search fields in the main menu and then I made submenu has data source query finds fields match the search criteria of the main menu.
after the user put values in the search fields he press in button has the following code:

Forms!SInquiry1!SInquiry2.Requery

but the problem in the nevigation buttons when he nevigate then make another search ,the subform displays data starting from the same positon of the previeous search field and not starting from the first field that match the search criteria
If he stoped in the third field in the first search nivgation, the next search diplays data starting from the third field no the first one. But I need to dipaly the first field

sory for my bad english.
 
Prince,

If you use the Master-Child links that Access provides for your
subform, Access will keep it in "synch" with your main form.

After the user enters any/all search criteria, just requery the
main form and Access will do the rest.

Wayne
 

Users who are viewing this thread

Back
Top Bottom