Combo box - report

  • Thread starter Thread starter John Martin
  • Start date Start date
J

John Martin

I am trying my hand at VBA programming. I created a database which included a
field containing the initials of the member of staff dealing with a patient. I
created a report which set out information including the initials of the staff
member. I amended the input form to include a combo box from which the user
selected the initials of the staff member. My report now shows a number instead
of the initials. I take this to be the reference to the table that contins the
initials. How do I replace the number with the initials on the report? I have
in mind something on the lines of:

If field = 1 Then
this control on the report = initials
End if

The main table is called "Patients" The field storing the allocated member of
staff is called "Case Open to". The table containing the initials is called
"Staff Members" and the field is called "StaffMemberInitials".

John Martin
 
-----Original Message-----
I am trying my hand at VBA programming. I created a database which included a
field containing the initials of the member of staff dealing with a patient. I
created a report which set out information including the initials of the staff
member. I amended the input form to include a combo box from which the user
selected the initials of the staff member. My report now shows a number instead
of the initials. I take this to be the reference to the table that contins the
initials. How do I replace the number with the initials on the report? I have
in mind something on the lines of:

If field = 1 Then
this control on the report = initials
End if

The main table is called "Patients" The field storing the allocated member of
staff is called "Case Open to". The table containing the initials is called
"Staff Members" and the field is called "StaffMemberInitials".

John Martin
.
Click to expand...
In Properties, look at the Row Source of your query. It
probably reads something like this:
SELECT [Query8].[StaffID],[Query8].[Initials] FROM
[Query8].

The next property down is Bound Column. If that is 0 in
this example, then StaffID will be shown. If it is 1 then
the Initials should display for you.

Roxie Aho
roxiea at usinternet.com
 
Please excuse my ignorance. What query? I have not created a query. Are you
saying that Access creates one?

John
 
Back
Top