Datasheet Edit/Add Form

[kwarden13]

Hi Everyone!



I have been working on a databse for users to search, edit, and add new vendors. I finally have a search query working and now am stuck on the datasheet sub form. I want to be able to use combo boxes in the datasheet. The Supplier ID and Supplier Name columns would be locked as these will never change. However, the user needs to update the normalized, immediate, and ultimate parent names.

I was thinking they could use a combo box to edit and the associated id would get updated. If they need to add a new vendor to that specific combo, a pop up could appear and they could add it.

Any suggestions?

[CJ_London]

google the use of the combo 'on not in list' event for ways you can do this

[orange]

However, the user needs to update the normalized, immediate, and ultimate parent names.

Wouldn't this destroy a lot of the historical info you have recorded?
Do you have a logging facility to show who change what (from what to what, when) sort of thing?

[kwarden13]

yes that is what I am doing now, however, do you know how to update the combo boxes. For example, if i select a different supplier i want the id to update but also if it is not a valid relationship in the hierarchy the immediate and ultimate boxes would need to change

[kwarden13]

Some background: the vendors are from account payable and I do not want these to change. However, my team manages the vendor rollup process and need to change various records weekly. For example if Pepsi buys coke my team would need to go in and search all records containing Coke and update the normalized, immediate, and ultimate names to Pepsi.