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!
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!