Remove from drop down list

[Downie]

Hello.

Form Setup

I have an ADMIN DETAILS Form(datasheet) with 2 fields

1.Schedule_run_order
2.ITEM(dropdown list = combo8) [valuescomes from Item Table]
ROW SOURCE = SELECT items.item_id, items.Job_Name FROM items;

A couple of After Update EVENTS are on these 2 fields

Private Sub Combo8_AfterUpdate()
DoCmd.Requery
End Sub

Private Sub schedule_run_order_AfterUpdate()
DoCmd.Requery
End Sub

The ADMIN DETAILS Form(datasheet) has an overal qurey running with a
RECORD SOURCE of;

SELECT details.id, details.header_id, details.schedule_run_order,
details.item_id
FROM details
ORDER BY details.schedule_run_order;

What I'd like is;

1.Have the ITEMS (combo8) to remove itself from the list when it is
picked and placed next to
a Schedule_run_order value in the ADMIN DETAILS Form(datasheet)

2.also Schedule_run_order cannot be null

Can anyone help with either of these to enhancments?

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), are two small Access database
samples called "MoveList1.mdb" and "Movelist2.mdb" which illustrates one
method of doing this. It might work for you, depending on the details of
your application.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L