Loading a record in a form

[Jay]

Hi,

We have designed a database where when you run a query it give you the
results of a client in a table. Is there a way to load the selected record
int the table to be loaded in the form the way it was created/inserted in a
form?

Help is apreciated.

Kind regards,
Jay

 

[Jeff Boyce]

Jay

Are you saying that you want the query to "feed" a form? You can do that by
creating the form and pointing at the query as the record source.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Jay]

Jeff,

My query is a search where the users can search for a record by entering few
letters of the clients details, by clicking search button, the results are in
table output where there may be hundreds of records but the user then may
want to click a selected record to open in a form based result. is this
possible to do?

 

[Jeff Boyce]

Jay

Here's a way I handled something similar...

A search box to start with, and a listbox to show 'matching' records. I
have the search box (a textbox) "wait" until after 3 characters are entered
before returning results to the listbox. With each additional search
character typed, the listbox narrows.

Then I use a second listbox to display records related to which ever one the
user selects from the first listbox.

This approach tends to keep the number of records/rows to a minimum, rather
than showing the user long lists.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP