about opening form with sepecific data to show Help Me Plz!!

[mk2lee1]

Hi, I have two forms called school and participation (1 to many relationship).
And they are linked by participationID. becuase its one to many relationship.. when i open the school form and click the button that opens the participation form, i get listings in the participation form but its initial listing is one with lowest participationID. Is there any where to make so that listing is according to highest ParticipationID?
thank you..

 

[missinglinq]

You don't say whether your forms are based on the tables or on queries (queries being the preferred way by most developers). If based on queries, go into your query design for the second form and for ParticipationID under "Sort" select "Descending".

Whether based on a table or query, you could also put in the form load or form open sub the following command:

DoCmd.GoToRecord , , acLast

Hope this helps.

The Missinglinq


"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[mk2lee1]

well.. its based on table...
they are all text fields.. in which data's are retrieved from table.. once you click on the button that opens the participation form... and automatically adjust data according to what school it is...