All available Oven for day in DropDown list.

[Guest]

Reposting since haven't gotten a response

tblovens(all availableovens)
I would like to create a drop down list for ovens ( for a record in the
subform). I have a table of all of
the available ovens for the day. Primary key is oven#.

I have a table that
assigns oven# to given orders. (call it order details) on this table there
is a checkbox field says OVEN no longer available for use.


I would like the order details form to have an oven drop-down
list(presently-pulling it from the ovens table- shows all ovens wether-not
really available)

Somehow when the users selects an oven for the drop down AND checks off the
box(even 1X) Not available( Need this field since one oven can be used on
multiple small orders through the day.- but check off NOT available if
slotted for one order for entire day.) Would like it to be removed from the
drop down list.

And at the end of the day - I would like ALL of the ovens to be RELEASED and
now all ovens
available for drop down at start of new day. This sound odd but it is how or
business works. Feel kind of looping - not sure how to do. Please help if
you can.

Thanks,
Barb

 

[Guest]

To get only available ovens to show in your combo, the row source for the
combo needs to be filtered on the field your check box is bound to. Then, in
the after update event of your orders detail form, you need to requery the
combo so it will include only available ovens.

Making all ovens available at the beginning of the day is a design issue.
The most simple way would be to create an update query that would set the
value of the available field and have a command button on a form that would
run the query; otherwise, to do it automatically, you would have to have a
way to know it is a new day. You could to that by having a one record table
that has one field with nothing but the current date in it. Then in your
startup routine, see if the current date is greater than the date in the
table and if it is, run the query and update the table.