The textbox HNo1is set to unbound, when the user click to select "I" on combo
box CobDis1 then HNo1 will enable and I want recordsource to be set to fields
name "h_no". How can I do this? Thanks for all respond.
Private Sub CobDis1_AfterUpdate()

I have a vbInformationBox that gives me a beep. How can I turn off the beep,
or replace it with another sound?

I know it is possible to set a field proporty to No duplicate in a table.
I want to do this on a higher level...in a Form instead..a ordinary field
that is not a Key field, maybe for a value entered in a cmb box in a subform.
Is this possible?

In Access Shift-F2 will allow editing a field's contents in a separate window.
While this feature is useful in editing longer values (e.g., memo fields),
it's annoying in that it defaults to selecting all text and carriage returns
close the window.  Users don't often know that ...

I have customized my own ShortcutMenu in which it has Macros as the Items.  
All is working ok.
What I would lke to know is that somtimes I would like certain Items of this
Shortcut Menu to be disabled & other items to have them all enabled.

I have a form with a tab control with a page with a subform control.  How do
I reference a field in the subform from the parent form?
I know that it's form!subformctl.form!field,  how for a tab?

I have a main form with three subforms.
Initially the tabs all work fine but after the first time the cursor enters
the subforms in the last field position ( ie two fields per record). The
cursor enters the fist record but in the second field. Do I set the tab index

On  an employee form, there is a sub-form which lists education (high
school, college, etc).  The subform is rather simple and really just lists
the degree, graduation date, and some comments for each degree a person has.
(The subform gets its data from a table where the record ...

I have a main from with a subform on it.  I'm trying to populate the
subform with fields related to the drop-down on the main form.  On the main
form is a drop down for company.  When I click and choose a company, I
would like the subform to populate with fields only pertaining to ...

What could cause an Autokeys macro to suddenly be unable to find a function?
I'm getting an error dialog that states:  "The expression you entered has a
function name that MyApp can't find."  The Action Failed box then opens to
indicate all correct Macro settings. I tried making the ...

I have a report that is for shipping Laundry daily. What is reported in the
report is the quantity of each laundry product and the product name that is
both shipped and received. What I would like to do is include, at the end of
each Product record, the year to date total of that ...

I have a calculated total on my orders_subform, I would like to pass this
value to payments_subform. Both of these subforms are contained on my main
form frminvoices.
Any tips? suggestions?

I have a Main Form with a Subform on it.  The Main form has a Calculated
Unbound Field based on the Sum of the Subform.  Whenever I delete a
record from the Subform you can see the field on the Main Form refresh
itself  Any way to hide this action?  I'm using code.

I have a data input form and need to automatically duplicate the existing
record as a new record in a new table (Annonce_OUi) by clicking a button.
Many thanks in advance!

I have a main form that has a subform on it.  Both the main form and
subform is using the same query.  But when I click on the navigation
buttons on the form, all the fields for the records change to the next
record but the subform cursor doesn’t move down to the next record.