Searching a table

N

ndunwoodie

I'm new to Access programming and am not clear as to how to program a search
of a table. I have a form with a combo box. When a user selects a
particular item from the combo box, I want to check to see if that item is
already stored in a table. If it is, I want to display a mesage that tells
them to choose another, otherwise they will continue with the next
instruction on the form. I am pretty familiar with Visual Basic, but not how
to get it to search a table. Any suggestions?
 
J

John Vinson

I'm new to Access programming and am not clear as to how to program a search
of a table. I have a form with a combo box. When a user selects a
particular item from the combo box, I want to check to see if that item is
already stored in a table. If it is, I want to display a mesage that tells
them to choose another, otherwise they will continue with the next
instruction on the form. I am pretty familiar with Visual Basic, but not how
to get it to search a table. Any suggestions?

Take a look at the online help for DLookUp in the VBA editor help
file.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

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

Top