Query Drop Down List

  • Thread starter Thread starter Sondra
  • Start date Start date
S

Sondra

Created a Query telling user to enter SOP Number which
opens just the necessary SOP.

I've created a form from the query. This works great if
the user knows exactly how the information was entered
into the SOP field; however, I want to know if there is
an option to just have the user locate the SOP from a
dropdown list in the form which would then fill in the
other information for that SOP.

That may be very complex, but I am sure there is a way to
do it, but not sure.

Thanks.
 
Created a Query telling user to enter SOP Number which
opens just the necessary SOP.

I've created a form from the query. This works great if
the user knows exactly how the information was entered
into the SOP field; however, I want to know if there is
an option to just have the user locate the SOP from a
dropdown list in the form which would then fill in the
other information for that SOP.

That may be very complex, but I am sure there is a way to
do it, but not sure.

Thanks.
Click to expand...
why not use a combobox?
 
Back
Top