In almost all of my history list, mostly in sub form based on previously chosen values of the main form & table, Access gives me a dialog box relating:
"Enter parameter value"
Formulaires!Entrepot famille création!Entrepot (As per example below)
Original A97 SQL:Système de gestion intégré.zip
FROM Entrepot INNER JOIN Famille ON Entrepot.Entrepot = Famille.Entrepot
WHERE (((Entrepot.Entrepot)=[Formulaires]![Entrepot famille création]![Entrepot]))
ORDER BY Famille.Famille;
Original A97 VBA AfterUpdate event:
Private Sub Actualisation_AfterUpdate()
' Rechercher l'enregistrement correspondant au contrôle.
Me.RecordsetClone.FindFirst "[Famille] = '" & Me![Actualisation] & "'"
Me.Bookmark = Me.RecordsetClone.Bookmark
End Sub
The biggest problem that I have, is that the Access passion that I had was in 2000. And just for the fun of it, I have designed an ERP (Enterprise resource planner) system that I could use today. It is not complete, but many features are functional. Roughly 50 tables, 100 forms, queries and reports.
I really do wish, "magical thinking!", only syntax changes are involved...
Thank you All !
Guy LeB
Note: I have attached my Database. If you solve my problem, fell free to use it but do not forget me...