Search results

okay, I'll try that. thank you!!!

Thank you so much, I'll try your instruction. Could I ask where could I learn about these code? Is there any course that you would recommend? I've learned through the basics of Access on Udemy, like how to create table, query, form, report, and just an introduction to VBAs. But I know I need...

UPDATING: I have successfully created a query to automatically update the VacancyStatus of each Location: But still I cannot exclude the Location from the drop down box when it has been assigned to a previous Lot. Anyone can show me where am I wrong?

I'm trying to create a drop down box like this, so that I can assign 1 (unique) location for each lot. But I would like the location value to disappear from the drop down box once it has been assigned for any Lot. As you can see in the photo, the location "M-1-1-10" is still on the drop down...

* I have 02 tables: [tblLotSys] and [tblLocationList] [tblLotSys] has 03 fields: [LotSerialNo] ; [ReceiptDate] ; [Location] [tblLocationList] has 02 fields: [Location] ; [VacancyStatus] the [tblLotSys]![Location] looks up value from the...