Using Form to Lookup/Search a Table

  • Thread starter Thread starter Jeffrey Wilson
  • Start date Start date
J

Jeffrey Wilson

I'm looking to see if someone can point me to either the Access Help pages or
another location which will describe how to use a Form and Subform to look up
a type in a specific value into a field and have it look up that information
(such as running a query would) but display it into a subform.

Thanks
Jeffrey Wilson
 
I little more information, which I hope will help:

I have a table holding information for rental items (roll-off bins). When a
bin goes on rent, its number is entered along with date it goes out on rent,
date it comes back, and location.

What I'm wanting to do is create a form which will allow me to search for a
specific bin number, then display bin information (in a subform I'm thinking
would be best) allowing someone to see all entries for that particular bin.

As I've been reading the help pages, I'm getting the impression a query
would be best to find the information, but I'm uncertain how to have the form
to run the query and then show the data for just that bin number query into
the form. It's frustrating because I feel like I'm close to the answer but
am missing something.
 
You can use the combo wizard to create this type of thing.
Put a combo in the main form's header.
When the wizard asks what you want to do, choose the option that lets you
find a matching record in the form.

So when setup, the combo will show you the bin number and after you select
the bin, it will filter the form to show only that record.
Your subform will have its link master and link child fields set to the
Primary key of the bin table, which will be the foreign key in the table the
subform's query is based on.
Once you click the combo and choose a bin, the subform will show the records
for that bin.

I am assuming that you have a table where you save the entries for each bin.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Jeffrey,
This may not be what you’re looking for, apologies in advance if it’s not,
but you may also want to take a look at Allen Browne’s search form. It’s very
flexible and allows you to search a number of ways. He also has a calendar
control that I‘ve added on my search form, next to his date text box that is
very easy to use. Users can then search for a particular date or date range
to see the rental bin information or other information you want to know (such
as your locations). I don’t know if this is something you need, but it’s
available just in case.

Here are the links:

Search form-
http://allenbrowne.com/ser-62.html

Popup calendar-
http://allenbrowne.com/ser-51.html

I hope this helps.
 
I sent this post 24 hours ago, but I notice it never showed up here.

You can use the combo wizard to create this type of thing.
Put a combo in the main form's header.
When the wizard asks what you want to do, choose the option that lets you
find a matching record in the form.

So when setup, the combo will show you the bin number and after you select
the bin, it will filter the form to show only that record.
Your subform will have its link master and link child fields set to the
Primary key of the bin table, which will be the foreign key in the table the
subform's query is based on.
Once you click the combo and choose a bin, the subform will show the records
for that bin.

I am assuming that you have a table where you save the entries for each bin.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Aria -

Thank you, that is definitely more than what I was looking for but is
excellent information and after reading over that page will be the route to
go. It definitely offers more flexibility to search more fields than I
anticipated and I believe will be helpful to others using the database.

Jeffrey Wilson
 
Jeanette -

Thank you for your input. This is great information and defnitely a way I
can go. I hadn't thought the combo cox would work but after reading another
link posted in this thread, I see it definitely is what I needed.

Thank you again
Jeffrey Wilson
 
Hi Jeffrey,
You’re very welcome. I only offered it as a suggestion because you mentioned
locations, dates and bin numbers. I don’t know about you but I hate having to
go back and re-do something I could have easily planned for in the beginning.
 
Back
Top