input box to update query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlee - 17 Apr 2008 17:20 GMT

Good Day,
I have a form that is linked to a query. THere is a search combo box that
the user can use to select a specific record and view the details of it.

I have a button in the footer of the same form that enables the user to
search for a record based on another criteria.

Question: how can i take the value entered in the input box generated from
clicking the button to update the query linked to the form, so that the form
displays the record

Signature

Carlee

Reply to this Message

Evi - 03 May 2008 20:12 GMT

Carlee, for some reason this seems to have been missed. You've probably
given up looking for an answer by now :(

If the user is entering Search criteria into the Input Box in the form, then
you need to use the form's Filter and Filter On property.

How you do this depends on the sort of data he is entering - does he want to
search a text, a number, a date field, part of a field? If you still need a
response to this, please
However you may be saying that (for some reason) your form is based on a
parameter query. If this is the case, then remove the parameters and let the
user employ text boxes and combos on the form.

To see this in action, See Allen Browne's example on
http://allenbrowne.com/ser-62.html

If you need help with doing this please write back

Evi

> Good Day,
> I have a form that is linked to a query. THere is a search combo box that
[quoted text clipped - 8 lines]
> --
> Carlee

Reply to this Message