Select Specific Database Records from Within a Form

Avatar

Avatar

onthegomiller

Avatar

onthegomiller

onthegomiller

05-10-2010

I'm trying to find an example of a simple form that has one text box, a button (that retrieves from the database) and one

additional field that will populate with information that was retrieved from the database based on the information entered into the text box.  I've been unable to find a SIMPLE example of this.  It can't be as complicated as it seems.  I just want to enter an id, click the button, retrieve data from the database based on the id and display one column of retrieved info on the form.  CAN ANYONE HELP ME, PLEASE?

View Entire Topic

Avatar

Avatar

onthegomiller

Avatar

onthegomiller

onthegomiller

06-10-2010

Thanks Paul, but I've already read this article.  I don't want to use a DDlist.  I want to incorporate a free-form text field where a user can enter an ID and then have the form query the database for that specific ID and ultimately return the rows of data to the form (where it can be modified and re-written to the database).  The DDlist is impractical when trying to work with a table that has tens of thousands of IDs.  I've worked with many forms tools before that all make connecting to a DB very easy.  Designer doesn't make it easy to accomplish something that should be very simple.  Thank you, again, however, for your reply.

Kim