I want to put a combo box on my form so that I can click on one of my
clients' names and have the form jump to that record.  Is this possible?
Thanks,
John

3 position client ID. Alpha. I only want to lookup records not add or
delete. Once a match is found, I want to display corresponding address, CSZ
on the same form. I'm assuming combo would be best. I cannot get the fields
to change when I select from combo list. I could skip this ...

Access XP
I have a form that is based on linked tables to a SQL server back end.
The table in SQL has a trigger that fires whenever an update is made
that recalculates some values of a couple of fields.  When a user is

I am attaching some code that I have been using in a form that has been
working for a while.  However, I just went to add some updates to it, and
discovered that it will no longer compile.  I am using AccessXP.  It stops at
the line

I need to bind a selection in a combo box to the rest of a form.
Table: ID,NAME,ADDRESS,CITY,STATE,ZIP - ID is 3 Letters.
I have all fields on a main form. I only want to display, not edit add or
delete. (which I have "NO" in form properties.)

Can someone give sample codes on how to cancel the data entry routine on a
subform where some required fields were left blank?  The error message is
"The field 'FieldX' cannot contain a 'Null' because the Required property for
this field is set to 'True'.  Enter a value in this ...

I have the the following code behind the after change event of a combo box:
Private Sub Combo50_Change()
Me.Filter = "MonthEnd=" & Me!Combo50
Me.FilterOn = True

I have a combo box with several combo boxes where changes in each must
cascade down and change the rowsource of the next.  That's all OK within
that form, but the problem is that I cannot find a way to invoke either the
Change or Afterupdate events when the selection in a combo ...

Is it possible to have a query that transforms the content of a field into
ASCI (SET of the 128 first characters)
The only solution that I see now is to do it with VBA Code with a first loop
on the records and a second on each character of the field

I have a form displaying publication titles for different subjects, like
group                        Subject                                        
  Title
 Law              Informationtechnology        The new Internet

For each record in my database I have a hyperlink, if a record doesn't have
an attached hyperlink I would like it to open a specific file. Heres what Ive
tried, bottom half works:
Private Sub ViewWI_Click()

Access 2002: I have a main form with a subform. I would like to subform to go
back to (a new record on) the main form, after ONE record in the subform.
The record on the subform is entered after a NEW record is entered on the
mainform.

I have a main form which displays data based on selections made by
user. Form load initially with no data in it. I have a sub form that is
supposed to be populated once a selection is made on the main form. The
problem I am having is that nothing is being displayed in the sub form.

How do I reference a field in a subform, in a main form, using VBA code? Hope
that makes sense!
Cheers

I have downloaded a template from Microsoft Online and am trying to customise
one of the forms to suit my specific needs. My problem lies in saving the
contents of each specific record, it is saving the defult contents (those
that came with the template) but those contents that I ...