combo box default values

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a form called history, where the user inputs an ID
number and a vessel number, and an associated date.

On another form called current status, the user inputs the
vessel number to update various items. They then have to
choose the correct id number from a combo box which gives
them a choice of all the id numbers from the history
table. Note: the vessel numbers will not always have
unique id numbers. They will carry one id number for
several weeks, and then change to another id number.

What I would like to do to make it easier for user input,
is... after the user inputs the vessel number on the
current status form, I'd like the id number on that form
to populate itself by looking in the history table for
that vessel, finding the most recent date, and
corresponding id.

Is this possible? Maybe I don't need the id on the
current status form to even be a combo box?
..
 
Tod,

What you need is a querry that will sort by the vessel
number then also use last date. Set a input field on the
form. input the vessel number then pick a button. This
button would run a querry that needs to sort by vessel
number, it then also groups by date, and latest date.
These are all done throught the wizard fairly easily. The
key is that you determine what you want to be the first
sort criteria. Then work your form out with querries so
that at the end you only have the options that you want in
the box. This box would be set to get the info from the
querry.

Kevin
 
Back
Top