How can I pick a record to goto when opening a form?

  • Thread starter Thread starter Paul Stenlund
  • Start date Start date
P

Paul Stenlund

How can I let a user pick a record (bill of lading number in this case) and
then open a form with that record - could also have form open then pick the
record to goto
 
you can use a combo on the form to select the value of the column you want
(order them for ease of use)

then use the recordsource

Select whateve it is you want (but including the yourcolumn - the one you
want to select on a value from)
WHERE yourColumn.value = [Forms]![the formname].[thecomboname]

on_open the form will be empty as tyhe combovalue will be Null or "" (can't
remember)

use the on_click event of the combo to requery the form

me.requery

the form populates with the record selected.

There's a specific access group for Forms issues public.access.forms which
might be a better place for your question

Ji m Bunton
 
On Thu, 27 Mar 2008 11:00:01 -0700, Paul Stenlund <Paul
How can I let a user pick a record (bill of lading number in this case) and
then open a form with that record - could also have form open then pick the
record to goto
Click to expand...

Use the Combo Box wizard to add a Combo to the form; choose the option "Use
this combo to find a record".
 
Back
Top