Access database problems

[Emily]

Hi I am putting the finishing touches on a database and
can't figure out how to have my query look up forms. I am
new to this. What we would like the database to do is
when I type in the address to search for to have the
query pop up with the name of the customer and then have
a "link" that takes me to the form. Is that possible?

 

[Tim Ferguson]

Is that possible?

Yes: it's fairly standard, and there are lots of ways of implementing it.
The drawback may be that you'll need some programming, and the robustness
and slickness of the final product will depend a bit on how much you are
prepared to get into that.

I have a little unbound form with a combo box and a list box: when the user
types a name and clicks the "Search" button, it creates the SQL for the
listbox which then lists all the possible hits. When the user selects a row
from the listbox and clicks "OK", it constructs the SQL for the
recordsource for the main form. The trick is that this is called from the
On Load event of the main form, so that it can also cancel the main form if
the user could not find the desired record. Or create a new empty record
and then display that.

You could also have a form in continuous-forms mode, with a command button
on each record saying "open this record", which would open a proper form
filtered to the record in question.

Or you could simply allow the user to toggle the same form between
datasheet and single form mode.

And so on. There is probably more help in m.p.a.formscoding

Hope that helps


Tim F