Recent content by DML

You need to requery the combo box on whatever even would result in that list changing. The code would look like: me.[Combobox1].requery if on the same form as the event or to fully reference it if combo box is on the main form: Forms![MainFormName]![Combobox1].requery if combo box is on a...

After you make your form as Mike mentioned, if the second option is selected, you can use an input box to accept the key field from the user in VBA. Syntax would be: Dim strInput as String strInput = Inputbox("Please enter number") Then use the string variable to assign the value to the...

If you are running that application from a network, make sure the directory that the application resides in has Create/ Delete rights for your users. When access opens, it creates an .ldb file to store record locking type information. If the user does not have these rights, the .ldb file will...

You should set the format in the table to the number of decimals that you desire (make sure that the number is a double or single, which is a real number (decimal)). Even if your form is set to a decimal format, if you have the field set as an integer, it will be saved as an integer (with...

You can set the enabled or locked property for the subform control that is on the page of the tab. You can also set the style property for the tab control to None. This will hide the Tab part of the tab, so that it will be transparent to the user that you are using a tab control (then they...

See my reply to your post in the General section

See my reply post to your question in the General section

No Problem about being new...that's what this site is for right!? The timing on changing the tabs depends on when you wanted to change the source object for the subforms. If you are still doing it based on a choice from a list or combo box, then the after update event of the list box or combo...

djh, Yes, that code should work, but you may experience some difficulties if you are using Link Master and Link Child properties of the subforms and if those properties will need to be changed when you set the source objects. If you are using a combo box to determine which subform to use, then...

Can you put subforms on your tabs and then put the controls for each tab on that subform? [It is actually done the other way...you would make the form (subform) first, then add a subform control to your tab (and set the control source to your new form) in place of all of the controls]. This...

If the activate button doesn't work for you, then try the On format event of the detail section. Your problem has to do with the timing on the population of the data.

I took the last Ampersand out (to wrap the line to the next line) and it eliminated the error message: MsgBox Err.Number & ": " & Err.Description, vbInformation, _ Me.Module.Name & ".cboShowJob_AfterUpdate" The message is clearer if you choose Compile All modules or compile all...

Make your last statement in your code me.[SearchTextBox] = "" or me.[combobox] = ""

Musicmaker, What error messages are you getting? You may have some properties set differently than I have assumed for the above example.

Actually, I think the syntax for the Open report command would be: DoCmd.OpenReport "MyReport", acPreview, "", "[IdField] = " & [Forms]![MyForm]![IdField]