Select record on subform

**bilalo** · 03-31-2023, 08:35 AM

I have a form and a subform. When I update a field in the subform, I need to refresh the parent form.The problem is that when the parent form is refreshed, the subform moves focus to the top row so I have to scroll down to go back to the row that I updated.I tried findfirst and bookmarks to select the updated row but with no luck.Any idea how to refresh the parent form while keeping the selected row in the subform focused?

**Welshgasman** · 03-31-2023, 08:38 AM

How are the form and subform linked?

**orange** · 03-31-2023, 08:55 AM

You may get some insight from this thread.
Requery Main Form after updating SubForm without losing position

**bilalo** · 03-31-2023, 09:32 AM

Originally Posted by Welshgasman

How are the form and subform linked?

Linked via ID

**Welshgasman** · 03-31-2023, 09:37 AM

And how are you refreshing the form?

**Micron** · 03-31-2023, 11:12 AM

When I update a field in the subform, I need to refresh the parent form.

That seems like an unusual requirement. Regardless, bookmarking the current record in the subform, refresh/requery main form, then go back to the bookmark is the usual approach AFAIK. If it didn't work for you, perhaps post what you tried.

**bilalo** · 04-01-2023, 03:51 PM

I bookmarked the current record then got back to it after refreshing but that wasn't enough.
I don't know why, but it seems that setting the focus to another control and then setting the focus to the subform made it work perfectly

Thank you guys.

Select record on subform

Thread Tools

Select record on subform

Similar Threads

Get a value from the current record in a subform and select that value in a combo box

Select Record bar does not show up on form when it is subform

select Subform record and go to record on form

Select Active Record in Datasheet SubForm

Using a listbox on a subform to select subform record.

Tags for this Thread

Posting Permissions