result

[Osyris]

Hi all
look what i have
one text field
one button
one text box
i want to type a word in the text field, press the button and any results
for this word will appear in the text box.
do i need a code or a macro??

I have a table with 2 colums
the fields of the first colum (named word) includes a "key word" and the
fields of the second colum (named results) includes the results for ony key
word from the first colum.

for example
word result
cat animal

thank you

 

[Alex Dybenko]

Hi,
you can write following VBA for command button click event:

me("text field")=dfirst("Result","MyTable","Word='" & me("text box") & "'")

of course - you have to replace control names with real one

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com