I have a form, which allows the user to select an option which then loads
appropriate information into a data entry form with a new record, into which
the selected value is passed.  passing the value to the second form works
fine, and is triggered by a button click event.  my ...

Hi,
How can I "refresh" a list box of values? That is, after the "refresh"
button is clicked, I need the list box ListBox1 to do the following:
1 - requery  (now using me!ListBox1.requery --> seems to work fine)

I have a small problem and need your will help . I have a form with a code
to lock all records on load.and a Button to Unlock a record.when i load the
form and choose a record to update.suppose the cursor is in field A, and to
unlock the record I clicked the button, here I want a ...

Hi could anybody help me?
I am trying to use the following code to populate a forms controls from a
combo box, the code from the combo box after update is as follows
Private Sub cboMoveTo_AfterUpdate()

I want to control the appearance of a subform based on a field value on the
main form. I'm using the Current event on the subform to change background
color, etc, and this works fine. However, if the subform has no records for
the student in question, there is no Current event ...

i am using a continuos form to display rows of data that contains two
comboboxes.
when the first in the row is clicked the seconds one's list items change.
right now when this happens all of the 2nd combo boxes contain the same

I have 3 main switchboards for 3 different applications.  My question is
can/how do you create 1 switchboard to take me to 1 of the 3 applications.
Thanks in Advance

I'm rather new at VBA and so this question may have a simple answer.  I'm
creating a form where I would like to place a DLookup in a control so that
once a choice is made in another control, the program will lookup its correct
counterpart.  I have used the DLookup before, and it ...

I am creating a form for the user to log events that have happened on a
particular day.  Once the day is done, they will create a new record at
midnite by selecting the "Next" button and enter the new date (or have the
data automatically be put in for "today" , if thats possible) ...

Is there any way to determine the length of a text field in VBA?
I'm not talking about the Len() command which returns the length of the
VALUE of the field, I'm talking about the FIELD SIZE which is in the table
definition.

[x-post & f'up2 microsoft.public.access.formscoding]
Hi!
How do I initiate a VoIP call (through a headset) from Access?
Thanks!

I have a form which I have set properties default view as datasheet. this
then opens in correct view except when I use a command button to open form
from another form what code do I need to add to open in datasheet view
thanks

I am receiving run-time error 2501.  The code that is producing this is:
Private Sub Get_Data()
   str_EmployeeName = cbo_EmployeeName.Value
   str_ClientName = cbo_ClientName.Value

I have a form with a combo box.  I want to send a mail automatically
when this combo box is updated.  I know I can use docmd.sendmail or
sentobject to automatically send this mail, however the table was
created long before we installed exchange server.  I am unsure how to

I have a form Company that contains a subform sfrmTasks that contains a
combo box that I want to contain the Contacts that are related to the
Company. Is there a way to dynamically fill the combo box based on the
Company in the parent form?