Sync subform's current record with form

darkmastergyz

Registered User.
Local time
Today, 14:32
Joined
May 7, 2006
Messages
85
Hi. I'm kind of stuck up with this thing:

So, I have a form and a subform. The subform's in the main form, and through the subform, I'm able to have a search for my db, because my subform is linked to a query, which gets the fields from my subform to do the search with.

Mainly when I search, I try to filter it down to a couple of records(my subform shows multiple records at once). When I select on a record on the subform say 21, I want my form to also go the record 21. That doesn't happen though, now. Now my form just stays at 1. I tried to do a work around by getting the CurrentRecord of the subform through a module and calling it from the form, but once I filter out any records, then they're out of sync, because the filter only says x out of (remaining records which fit the filter). So, how can sync which record my subform is on, and my main form is on?

Thanks!
 

Users who are viewing this thread

Back
Top Bottom