Re: Use stLinkCriteria for 3 fields

Donna, I agree with John that adding an AutoNumber to your table will be
easier than trying to handle the 3-field combo.

It will also simplify your life when you come to create related tables for
these entries.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"John Vinson" <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:igqr129gf6ig863nsbpre07ha0tv00srna@xxxxxxxxxx
On Sun, 19 Mar 2006 09:01:32 -0800, Donna
<Donna@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Thanks, Allen! Along similar lines, I have a combo box for doing
"searches"
on a form. Again, the Primary Key is composed of these same 3 fields.
But I
can only get it to bind to 1 column; I need it to bind to all 3 columns.
Right now, if I search for "Smith" & there are 3 "Smiths", it will only go
to
the 1st "Smith", even though I am selecting the 2nd or 3rd one. I assume
that's because it can only be bound to column 1. Can I bind it to 3
columns?

You'll do much better to have a unique PersonID (which might not be
meaningful or visible to the user), and use it as the bound column of
the combo.

John W. Vinson[MVP]


.

Relevant Pages

  • Re: Use stLinkCriteria for 3 fields
    ... the Primary Key is composed of these same 3 fields. ... can only get it to bind to 1 column; I need it to bind to all 3 columns. ... meaningful or visible to the user), and use it as the bound column of ... John W. Vinson ...
    (microsoft.public.access.forms)
  • Re: Filling in my table
    ... Good answer, John; however, if Dahlman may not be familiar with how to ... DepartmentID since it is the bound column. ... >>table with autonumber deciding my primary key for each department. ... >>report I do not know how to take all the primary key entries (all auto ...
    (microsoft.public.access.forms)
  • Re: Calculate certain number of records
    ... press Ctrl+G to open the Immediate window. ... Tips for Access users - http://allenbrowne.com/tips.html ... Getting a value from a table: DLookup() ...
    (comp.databases.ms-access)
  • Re: Combo Box look up
    ... >Do you know what is the sytax for the "Bound Column" row in the Combo Box ... What are you trying to store into it? ... of people's names have a unique Primary Key (if this is the military, ...
    (microsoft.public.access.gettingstarted)
  • Re: Combo Box Source from Same Table
    ... and a Bound Column of 1. ... I'd use a calculated Field so that the name showed as "Smith, John", ... shows the names but is bound on the EmployeeID column. ...
    (microsoft.public.access.forms)