Solved

Refresh Access Query Data

Posted on 2014-11-15
5
509 Views
Last Modified: 2014-11-17
I have a Form with a ComboBox that uses a Select Query to select data to be used to create a new record in a table[REGISTRATION].  The query uses the same table [REGISTRATION] that I am creating the new record in.  Once I select an option in the ComboBox and save the record containing it to the table [REGISTRATION], I don't want it to be available again in the ComboBox.

If I close and reopen the Form the new record in the table [REGISTRATION] no longer displays in the ComboBox which is what I want.

How do I get this to happen without closing and reopening the Form?
0
Comment
Question by:Bob_Collison
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 22

Assisted Solution

by:Kelvin Sparks
Kelvin Sparks earned 250 total points
ID: 40445003
Try using this code in the after update event of the form

Me.comboname.Eequery

replace comboname with the name of the combo box.

Kelvin
0
 
LVL 50

Accepted Solution

by:
Gustav Brock earned 250 total points
ID: 40445005
You can run this code in the AfterInsert (or AfterUpdate) event of the form:

    Me!cboYourCombobox.Requery

/gustav
0
 
LVL 34

Expert Comment

by:Mike Eghtebas
ID: 40445235
To your table, add a Yes/No field called RegisteredYN. Add this field (RegisteredYN) to your combo box rowsource. Set its criteria to false in the query feeding the combo box.

Additionally, add RegisteredYN also to your form (you can keep it visible or invisible). However when registration is complete, up on saving the competed registration have:

Me!RegisteredYN = True

This way, a registered record will not show up again in your combo box.

You also need to add the following to the OnEnter event of your combo box:

Me!cboMyComboBox.Requery

Mike
0
 

Author Closing Comment

by:Bob_Collison
ID: 40448582
I selected the two solutions because they are virtually identical (as I assume the first had a typo of eequery). and they are the simplest to implement.  I didn't try Mikes but it appears it would work but is much more complicated.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…
Introduction to Processes

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question