Search results

Again, thank you all for your input. Regards Richard

GREAT this works fine. You make me very happy,Yes!!! Regards Richard

Hi Colin, Thank you very much for your input!!! This might help me in some other cases, I'll remember this solution. In my case however my subform is not connected to a form so "SubFormControlName" will not work. My "Sub"-form is in fact a form, oeps. Later on, when it is working proper, I'll...

Thank you all for trying to help me, but I can't get it to work... and... I'm just curious if it works. I know there are better methods. The answers confuse me a bit. What should be the complete code for "on load"? I want to run the query “Qry_004_Settings_Admin” while calling the form. Private...

It is always good to think out of the box...

Just out of curiosity: A form is usually based on, for example, a table or a query. You then enter the name of that table or query on the second tab (in this case “Qry_004_Settings_Admin”) and the form will then retrieve the records when opened. Question: Is it also possible to NOT enter...

Great, that's what I'm looking for. Works fine, thanks, Richard

Sorry, I'm new and posted this thread in the wrong forum. I posted now in the Forms-forum.

In a form, an apostrophe may not be used in an input field (all other characters do not cause a problem). There are 2 options to solve this: 1. If the apostrophe is used, it will automatically be replaced by an underscore (with action "Replace"). 2. If the apostrophe is used, a messagebox will...

In a form, an apostrophe may not be used in an input field (all other characters do not cause a problem). There are 2 options to solve this: 1. If the apostrophe is used, it will automatically be replaced by an underscore (with action "Replace"). 2. If the apostrophe is used, a messagebox will...