Use a parameterised view.

When you reset the record source, gids drop all the information you see lost. Parameterised views allow you to change the underlying data without changing the recordsource.