Re: creating search form

From: Shiner452 (Shiner452.16fqy7_at_nospam.MSAccessForum.com)
Date: 05/17/04 

Date: Mon, 17 May 2004 08:51:46 -0500

There are several ways to do this...the easiest is probably this. Set
your forms recordsource to the table your data is in. Add a combobox
and select the 3rd choice in the wizard 'Find a record in a
table/query'. Select the ID# field as the data you wish to display.
Next, select all the fields whose data you wish to display and place
them in the form. Whenever you select an ID# all those fields will
show the information for that record. If your data is spread out
through more than one table, create a query for all the necessary
tables and base your form off that query.

Let me know if you need any more help.

Shiner

------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

Relevant Pages

  • Re: Query to populate combobox with names of tables, only if they contain data
    ... my case, I wanted to not display the names of empty tables at all, so I ... SELECT "data-chiroptera" AS TableName, Countas RecordCount ... I have a form with a combobox, populated by names of tables in the ... The source for the combobox was this query: ...
    (microsoft.public.access.forms)
  • Re: Combo box / Subform Question
    ... After the combobox selection is made, ... the query sees the selected record and that one gets displayed on ... "Jeff Boyce" wrote: ... value to find the correct record to display. ...
    (microsoft.public.access.formscoding)
  • Re: Current Row or similar for query-based combo box
    ... Based on a prior post, I have created a form to access my table. ... form.in my combobox query I am able to get the intended result. ... rows that need other values to display will suddenly display blank. ...
    (microsoft.public.access.queries)
  • Re: Blank form
    ... > bound controls on the form to display all fields from the query. ... > I then added a combobox based on a simple query on one other table. ... When the user with full permissions ...
    (microsoft.public.access.security)
  • Re: AllowAdditions=False makes unbound controls blank out when recordcount=0.
    ... If the RecordSource is not a read-only query, one workaround is to allow the ... You can place other controls in the Form Header section and they are ... there are still display problems with those ... > the after update event of the combobox. ...
    (microsoft.public.access.forms)
Loading