Searching a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

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
 
Back
Top