Re: auto fill using combo box

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello,
I added the new description field to the query behind the combo. then on
After update I typed in the destination of the field on the form = cbo with
the name of the combo box.Column(1). and after saving it, I got an error
stating that it cant find the macro [name of filed destination on current
form]=cboNameofcombobox. I am typing it out with these descriptive names
just so I know that I understood what you told me to do. If I misread your
instructions or if you have further advice I would apprecite the help.

thank you in advance

titan

"Al Camp" wrote:

> Titan,
> Make your combo a 2 column combo by adding that Description field to the
> query behind the combo.
> Then, on the AfterUpdate event of the combo... (use your own names)
> [MyFormDescField] = cboYourComboName.Column(1)
> (combo box columns are numbered 0, 1, 2, etc.. so the second column would be
> Coulumn(1))
> hth
> Al Camp
>
> "titan" <titan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:82D2B624-FB5B-4536-A1C9-A6366BA7A7E5@xxxxxxxxxxxxxxxx
> > Hello,
> > I just had help creating a form that searches and it works. now im stuck
> > on
> > trying on I am trying to use a data entry form that has a drop down combo
> > box. when i select from that list, I would like another field, that is
> > next
> > to it come up with a description of what that combo box information
> > represents. the combo box information and the description is information
> > coming from the same table.
> >
> > Please help if you can.
> >
> > I appreciate it very much
> >
> > titan
> >
>
>
>
.

Relevant Pages

  • Re: auto fill using combo box
    ... > I added the new description field to the query behind the combo. ... > stating that it cant find the macro [name of filed destination on current ... >> Al Camp ...
    (microsoft.public.access.forms)
  • Re: Data Driven Query Task and Parameterized Update
    ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > I'm running into difficulty usinging parameters in my data driven query ... > destination table to see if a record exists. ... The error refers to an access violation. ...
    (microsoft.public.sqlserver.dts)
  • Re: Run append query from another database
    ... In order to suppress the display of the action query confirmation messages, ... you can put a SetWarnings/No action in the macro, ... but any records that don't exist in the destination ... and "Yes" to append the rows. ...
    (microsoft.public.access.macros)
  • Re: Importing Data from one Access DB to Another
    ... > In that case you'll probably need to build three queries for your macro ... (I.e. the query joins the two tables on their primary ... > source table but not the destination table). ... > John Nurick ...
    (microsoft.public.access.externaldata)
  • Re: Append Query Multiplies Records Thousands of Times? Access 200
    ... Normally you don't include the destination table (you are appending records ... So if you are using the grid, ... One method to handle this with the query grid is to build a SELECT Query ...
    (microsoft.public.access.queries)