Combo Box Problems.

  • Thread starter Thread starter Bayou BoB
  • Start date Start date
B

Bayou BoB

I have a Client table, with has many relationships, and I want to be
able to put in a combo box at the top in order for employees to not
only be able to enter new clients...but also to quickly get to an
existing client to edit the file. When I try to do this, it will not
allow me to. It will either show the names, and once you select it,
just sit in the box rather than bringing up that file... or it won't
let me pick anything at all, citing that it can't write the value in
the ClientID box since it assigned via autonumber. The fields are as
follows in the table...(shortened dramatically)

ClientID - Primary Key Autonumber, indexed, no duplicates
Last Name
First Name
Date of Birth
Address
Address1
City
Province
P-Code

I made a query of this table in order to make a "name" box....putting
both names together so it can be repeated on some tabs for the form I
built. That portion works fine when you add in a new client. However I
can't seem to get a drop down box based on the ClientID and Name, in
order to get the existing record for that individual to come up. What
am I missing here???

Kevin
 
The combobox on your form is probably part of that particular record... i.e.
if it shows the client name Mr Brown, then it indicates the record pertains
to Mr Brown... e.g. its RecordSource is bound to a field in the table
containing that data. If you want to use a combo to choose which record to
show, then you need an unbound combobox, with its list populated with client
names and its AfterUpdate event has SQL to filter the form's RecordSource to
just the client records chosen.

HTH.

Tom.
 
You'll need a separate combo box to find the record you want, not the one
bound to the table.
If you use the Combo Wizard to create the new combo, select the 3rd choice
on the first page, something like 'Find a record ...'.

When done, select the record wanted in this combo, and only that record will
be shown in the form.
 
Back
Top