Check Listbox values...

L

Lynn Pennington

Hi.
I want to check the values of a list box before I ADD a
record.
Thanks,
Lynn.
 
L

Larry Linson

Check _how_ or _for what_?

To use VBA code to check, put that code in the BeforeUpdate event of the
Form. If it fails your validation, set Cancel = True to cancel the update
and set focus back to the Control that was the culprit.

Larry Linson
Micrsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Split form 0
Populate a table based on check box status 2
Newbie Help - IF Yes No Function 0
Autonumber field in Excel that behaves the same as Access 0
Spell Check issue 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
list or combo box 0

Top