populate child form by record from parent form

[June7]

Why would users be editing the lookup tables? If lookup table record is edited, that edit will reflect in EVERY tblRequests record the lookup record is associated with.



Normally a form does data entry/edit for only one table.

If you want to allow users to edit the lookup tables, that should be done on a separate form. If you want to allow users to add new lookup records during data entry to tblRequests, explore use of combobox NotInList event.

[eugzl]

For editing record and add new record in fInventory form I created two options:
1. To add new record the form has New Request button,
2. To edit record user has ability double click record in the ListBox
For both cases will call fRequest form. When I finish project I would like to hide all objects from user and will give access only to the forms. What do you think about this idea?

Thanks.

[June7]

Hiding Navigation Pane, customizing ribbon, disabling shortcut menus, disabling function keys (in other words, securing the database) is common topic. I have done all.