Kan forestille mig noget a la at gøre formen/dataene skrivebeskyttet og så "åbne" vha. VBA når der trykkes på knappen, for straks derefter at "lukke" igen.
Hmmm.... spørgsmålet skulle nok nærmere have været: Hvis et felt ikke har fået indsat en værdi (f.eks. positive tal), skal dataene ikke kunne gemmes. Men det skal ikke laves med en Undo, dvs. så brugeren skal gen-indtaste alt forfra.
The validation rule isn't doing it's job! Here's the rule: Is Not Null Or >0 and the message to go along with it: "Du skal indtaste et antal kartoner større end 0!
If nothing is entered in the field, no message is displayed and my form moves to the next record!!! :(
Another question, same form: How do I navigate from a field in Formularhoved to a field in Detaljesektion? I wan't to be able to tab from my "Select order" dropdown in Formularhoved to a field in Detaljesektion.
You might have misunderstood (or I am now...), but I mean: The user should be able to use the Tab-key on the keyboard to navigate to the field in Detaljesektion (and back, if he/she so chooses)
The sub form will be in the Tab Order list which you can find in the Right click menu. To get back from the sub form I think you can use Ctrl+Shift+Tab but this may be effected by other properties such as the forms Cycle Property
I'v enever really understood how the Tab works between forms
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.