Fields from same record as choices for combo box?

E

eprman1

Hi,

I have 4 fields in a record that I would like to make choices for a combo
box. I know that usually a combo box gives the choice of the SAME field for
DIFFERENT records. Can it be made to select DIFFERENT fields from the SAME
record?

How?

Any help is appreciated.
 
K

Klatuu

Do you want the field names or the values in the fields?
If you want the field names, you can specify that in the combo's row source
type property in the properties dialog.
If you want the field values, you will of course, have to identify the
record you want. You will need to set your rowsource something like:

SELECT Field1, Field5, field3, field 12 FROM SomeTable WHERE ???

Then each time you change records, you will have to requery the combo. Do
that in the form's Current event.
 
E

eprman1

That gives me 1 choice, with 4 fields across. I cannot individually select a
field.
 
E

eprman1

I have a table EPRCUST which contains all of my customer data, including 5
fields, CUSTID, LNAME1, LNAME2, LNAME3, LNAME4.

I have a form to input data into a second table, [SERVICE RECORDS].

I am trying to use a nested combo box. I select the CUSTID from the EPRCUST
table. This works fine.

I then want to use a second combo box, based on the first one, so only the 4
LNAME fields are available as choices. The problem is that I can only get
the 4 LNAME fields to show in columns, as part of a single record. So
whichever I set gets changed to the CUSTID field for those LNAMEs.

I would like the 4 LNAME fields to show up as separate choices, each on its
own line in the combo box, so that name can be stored as a record in the
[Service Records] table.
 
Top