Requery Problem - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Requery Problem

Richard Lanoue

4 years ago

I set a drop down combo box where if a customer's name is not on the list, it opens up a form where I add the cutomer to the list. once it closes, it like it to requery the customer table. and go back to where was in the dropdown combo and put in the customer name. How do you do that?

	Kevin Robertson @Reply 4 years ago
Use DMax to get the last CustomerID in the table and set your Combo Box to that ID.

	Richard Lanoue OP @Reply 4 years ago
What my problem is, when the Contact form pops up and I enter the data, into it, I want it to on close event requery/refresh the ContactCombo box on the intial form (Which was what prompted the Contact form for not being on the list). Curently I have to close that form also and reopen it so the combo will requery. I tried Forms!CompanyF!ContactSubForm!ContactCombo.Requery...doesn't seem to work

	Kevin Robertson @Reply 4 years ago
`Forms!FormName!ComboBoxName.Requery`

	Richard Lanoue OP @Reply 4 years ago
Tries that unfortunetly it doesn't work

	Kevin Robertson @Reply 4 years ago
If the Combo Box is in a Subform you need to specify `.Form`: `Forms!CompanyF!ContactSubForm.Form!ContactCombo.Requery`

	Dan Jackson @Reply 4 years ago
Have you reviewed Relational Combo? - https://599cd.com/blog/display-article.asp?ID=1752 Don't forget to check out the Ext. Cut which, as a silver member, you have access to.

	Richard Lanoue OP @Reply 4 years ago
Thanx Kevin, but Forms!CompanyF!ContactSubForm.Form!ContactCombo.Requery didn't work. I''l check out the video Dan Thank you both

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

Next Unseen

New Feature: Comment Live View