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

[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

 

[Jim Bunton]

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

 

[John W. Vinson]

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

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