Re: Combo boxes and search forms

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Yes that helps. How would I code it to search the combo box and get
results to display the records with the matching values? That is where
I am stuck.

Thanks in advance for any advice.


J. Goddard wrote:
To refer to the violator_Id in the combox box, use: combo_box.column(0)
Is that what you are asking?

John


allie357 wrote:
I have a bunch of combo boxes that are unbound and get their values
from this type of query:
In this particular example it takes the violator_ID and name from the
violator's table and displays just the name.
SELECT tbl_Violators.Violator_ID, [Violator's Last Name] & ", " &
tbl_Violators![Violator's First Name] AS [Violator's Name] FROM
tbl_Violators ORDER BY tbl_Violators.[Violator's Last Name];

But I need to be able to use the combo to search the violations table
where the violations ID is stored as a foreign key.
I need to know if it's possible to just look at the violator_ID value
in the combo and comparing it to the equal id fk in the violations
table and display them in a subform. I do not have lookup fields, just
primary and foreign keys. I need to build the search/edit form for the
violations table.


.

Relevant Pages

  • Re: Combo boxes and search forms
    ... But I need to be able to use the combo to search the violations table ... where the violations ID is stored as a foreign key. ... table and display them in a subform. ... I need to build the search/edit form for the ...
    (microsoft.public.access.forms)
  • IE 7 has encountered a problem and needs to close
    ... violations. ... I also went to isnoop to track a package and IE would not ... display the RSS feed but trusty firefox ...
    (microsoft.public.windowsxp.perform_maintain)
  • Strange access violations
    ... A program of mine that was working is now giving strange access ... violations for a user in several different places. ... It will display the first message, ...
    (comp.lang.pascal.delphi.misc)
  • Re: Error in Append Query.
    ... field that is a foreign key to another table, and the value does not match ... >> Allen Browne - Microsoft MVP. ... >>> When run the query gives me the following error. ... >>> lock violations and 0,records due to validation rule violations. ...
    (microsoft.public.access.queries)
  • Re: What am I doing wrong here?
    ... The problem is with the foreign key. ... zladnaj Wrote: ... > Microsoft Access can't append all the records in the append query. ... > recorddue to lock violations, and 0 recorddue to validation ...
    (microsoft.public.access.queries)