Search results

Form spreadsheet view BUG I have serious problems when viewing forms in spreadsheet View. I have forms named Form1, Form2 and Form3. All forms is viewed in datasheet view. Form3 is subform to Form2, and Form2 is subform to Form1. When I click the + sign next to a record (say, record #3) in...

Yes, you wrote in your first post that you were using a touch-screen. I know you wrote that. Maybe I should explain more in detail what I mean: A listbox is what you need if you want more than one button, and want to get the labels of the buttons from a table/query. Use the On_Click() Event of...

Buttons do not have any controlsource, so this one can be tricky for continous forms. Why don't you just use a list control? They work the same way as an combo box, except that you can see the list all the time and don't need to click that down-arrow. Plus you cannot write the value to a list...

Why do you need to have a label? If it is because you don't want the user to edit the field, instead have a textbox that is linked to the field, then set the textbox's locked=true, enabled=false, and if you then format it border-less and transparent, it'll look exactly as a label. And no VBA...

To get replies on you question, please be more specific of what you mean, e.g. what do you mean with select, in a list box, or what? select a record?

Thank you! This worked perfectly! Thanx alot!

well, you don't have to have the sub forms show up in the same sub form window. Just have two sub form windows with the same Left, Top, Width and Height properties. let say you name the subform controls sf1 and sf2. set the visibility to true for sf1 and false to sf2. then have a command button...

Form1 has a sub form, Form2, which have a tab control with a number of tabs. One of them, Tab4, includes a sub form, Form3. I have an SQL statement that I want to run (using DoCmd.RunSQL) when Form3 is shown on screen the first time, e.g. when Tab4 activates. I've tried OnClick for Tab4...