query tables for incomplete orders

[Zedbiker]

I have an ordering database. I would like the ordering staff to be able to
see if there are new orders from the front screen (switchboard).
When the ordering staff sign off an order they tick a box which removes it
from the list of items on order.
Does anyone have any ideas or advice as to how I look up the orderdata
tables and flag the ones which have not been signed off to the switchboard? I
know what to do once the information is there but I am having trouble getting
it there.

Many thanks in advance for any help.

 

[Wayne-I-M]

Just an idea !!

Create a query with the order information (just the very minimum requed to
see if the order is completed). Include the tcikbox field.

Create a new form based on this query.
Filter the form (not the query) with the tick box being =0
Place the form as subform on the switchboard
Put an AfterUpdate on the tickbox (me.requery)

This will show the users which order have not been completed and allow them
to remove order after they are complete.

You may want to have a show all button on the subform in case there is an
erro - up to you that. This is why you don't want to use a QBF

Good luck

 

[Zedbiker]

Many thanks. That is exactly what I needed to do.
I was trying to make it too complicated.
Many thanks again for your help.

Ian