Pass details of a field into a query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a date field & a staff name field. I want to be able to
pass that date field into a query on a seperate table that would then
populate names for a dropdown list that would then populate the orgonal
table. Thank you
 
Thanks for your interest Steve.

I have 2 tables. One that shows peoples unavailability. showing date, their
location, reason (ie sick, roster day, annual leave).
The other table shows people available to take their place. showing date,
their name, if they are available.

i want to be able to have a dropdown in the first table on a field that says
who the unavalable person will be replaced by. The catch is that i only want
to dispaly people who have made themselves available for that day.

therefore the way i see it there needs to be a query that checks that & only
populates the names that have made themselves avalaible for that day.

which leads back to the origonal question. the query needs to be able to
look at the date field on table 1 to insert into the query to give the
available names.

hope this makes sense & thankyou for your time.
Todd
 
Back
Top