Syntax for tab control - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Syntax for tab control

Eric Michalek

4 years ago

I have a form (PowderF). It is it's own form that adds, edits, and deletes my powder records.
My Main screen (MainScreenF) has a tab control (TheTab) with page (PagePowder), on that page I have a subform (PowderListingSubF) that contains a form (PowderSelectionF).

My problem: When I add a record with (PowderF) and click my command button (SaveB), I want the new record to be visible on my (PowderSelectionF). If I click F5 on my keyboard, the form shows the added record.
I have been blindly trying VBA variations to do what F5 does but no success. example of an attempt that does not work:
Forms!MainScreenF.Controls!TheTab.Forms!PowderSelectionF.Requery
Can you help?

	Kevin Robertson @Reply 4 years ago
The first thing you need to do is make sure the record is saved to the Table. `Me.Refresh` Next you need to access the Pages property of the Tab control so access knows which page the Subform is on. You can either refer to the Index of the page (zero-based). `Forms!FormName!TabControlName.Pages(0).Requery` Or to the name of the page. `Forms!FormName!TabControlName.Pages("Page1").Requery`

	Eric Michalek OP @Reply 4 years ago
I tried this but it didn't work. Still need F5 as the form does not show the new record.

	Kevin Robertson @Reply 4 years ago
The code seems to work for editing records but not when a new record is added. I rarely use the Tab control but after some research I found that you don't actually have to reference the Tab control in your code. `Forms!FormName!SubformName.Requery`

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View