Solved

Refresh Access Query Data

Posted on 2014-11-15
5
459 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
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 49

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 33

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Computer science students often experience many of the same frustrations when going through their engineering courses. This article presents seven tips I found useful when completing a bachelors and masters degree in computing which I believe may he…
This article will inform Clients about common and important expectations from the freelancers (Experts) who are looking at your Gig.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

772 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