Requery Subform from Subform - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Requery Subform from Subform

Kaibaua Airam

4 years ago

Hello Richard and Other Guys

I have a form with 2 subforms on it, subform1 and subform2. Is
there some way to requery subform2 from subfrom1 or requery subform1 from subfrom2?

Forms!Mainform!Subform1.Form!Subform2.Form.Requery does not seem to work.

	Kevin Robertson @Reply 4 years ago
Try it like this: `Parent!SubformName.Form.Requery`

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
By your images you are referring to the wrong parent form. Shouldn't it be MainMenuF, not EmployeeF? `Forms!MainMenuF!StockInHandF.Form.Requery` Or just use `Parent` as I did in my first reply. `Parent!StockInHandF.Form.Requery`

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago
Hi Kevin My Form name EmployeeF and Main Menu is the Form Caption

	Kaibaua Airam OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
What is the name of the subform object?

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago
ItemF and StockInHandF

	Kevin Robertson @Reply 4 years ago
That's not the name that is the Source Object. That's okay though because I see the name in the combo, which actually seems to be mis-spelled (It says `Stoct In Hand`) `Parent![Stock In Hand].Form.Requery` You will need the square brackets since you have spaces in the name of the Subform object.

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kaibaua Airam OP @Reply 4 years ago

	Kevin Robertson @Reply 4 years ago
Take a look at the spelling in the name property.

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

Next Unseen

New Feature: Comment Live View