Please help me how to program the search button...

[cadmaster]

Hi,
Could someone please help me to program the search button so they can return and says, enter is invalid?


Please see attached image.
Thanks

[June7]

Why don't you use a combobox?

[Dal Jeanis]

In the VBA behind your button, you can use DCOUNT (for example) to detect whether the entry exists in the table, then issue a cancel or error message.

[cadmaster]

Hi Dal Jeanis,
Could you please show me how? I am just a beginner.
Thanks
Phe

[cadmaster]

Hi June,
How can I use combobox for this?
Thanks

[ItsMe]

What June and Dal are eluding to is that the value of EDO is known. It is a value within a record that resides in a table. You can use the wizard to create a combo box and have the combo box look at the table where the field EDO is.

You can use the dlookup function to lookup the value in this table.

Letting the user type miscellaneous text into a control is asking for trouble. So, you are right, you need something to tell the user they are typing invalid data or you could provide them a list of options with a combo box or something.

[June7]

A combobox would give users a list of valid choices. If the combobox LimitToList property is set to yes then users can select only from the valid items.

[Dal Jeanis]

The wizard should walk you through it pretty easily.

Here are some more resources for understanding (and setting up) combo boxes.

http://fisher.osu.edu/~muhanna.1/837/MSAccess/tutorials/combo.pdf

http://office.microsoft.com/en-ca/access-help/customize-a-list-box-combo-box-or-drop-down-list-box-HP005187786.aspx

http://www.fmsinc.com/MicrosoftAcces...xes/index.html