Opening a form from inside another form using ID

[bobunknown]

Roger that Minty.

im treating the notes section sort of like a doodle pad as there are those in the office that are.... averse to change... and don't like keeping all digital records instead of having paper everywhere.

Im using it more as a space for those people to scrawl their notes and therefore reduce the impact of having a digital workspace. All its really going to have in it will be notes like 'Bins round the corner' or 'Blue bins belong to next door'

Otherwise I feel you and all the others would be correct with regards to date and time stamps with individual records.

Ill probs use your suggestions and what I've learned for the implementation of a contact log in the future though. Always more to do.

Thanks guys

 

[Rafal]

You may build pop-up based on the query. In the query there will be criteria in ID column [Forms]![=parent form name]![=name of box in the parent form with ID] and in second column Note. By any command when necessary you are opening pop-up. Query has to be based on the same table as parent form. Before pop-up is opened RunMenuCommand /SaveRecord has to be done and before closing pop-up also.

 

[mike60smart]

Hi

See the modified db attached

View attachment Test Database - Removed info.zip