B
Byron
Try creating a query that will return the list of values
you are wanting the user to select from. Then set that
query as the "Row Source" for the combo box (you'll be
able to select is from a list in the row soruce property
of the combo box control).
HTH
Byron
Combo Box, which obviously is populated from the form's
record source table. Basically, OnLoad the form will pop
us a combo box with list of items for the user to select
from then open the form with only the value supplied by
the user using that combo box. Is this possible? I know I
can use a parameter query, but that will require a user
to type the full item description and I don't want that.
There are too many items to remember so the user just
needs to be given a list of items from which he/she can
select one to view its related data in the form view. Is
this possible in a form (VBA)? How? Or can an Access
query (SQL) do this?
you are wanting the user to select from. Then set that
query as the "Row Source" for the combo box (you'll be
able to select is from a list in the row soruce property
of the combo box control).
HTH
Byron
form needs to ask the user to select a value from a given
Combo Box, which obviously is populated from the form's
record source table. Basically, OnLoad the form will pop
us a combo box with list of items for the user to select
from then open the form with only the value supplied by
the user using that combo box. Is this possible? I know I
can use a parameter query, but that will require a user
to type the full item description and I don't want that.
There are too many items to remember so the user just
needs to be given a list of items from which he/she can
select one to view its related data in the form view. Is
this possible in a form (VBA)? How? Or can an Access
query (SQL) do this?