lookup value on form in a table

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

I've been reading through some of the posts, and I know this has been
answered, but it's a little confusing when you're using different field
names. Here is what I'm trying to do.

In my form, I have a combo box called [Parent Company] & a text box called
[GID]. The [Parent Company] is a pull down list that is looking up values
off a table called [Company Names]. In my [Company Names] Table there are
only two columns, one is "parent company" the other is "GID". Each company
name has a GID associated with it. What I would like is when someone chooses
a company name from the [Parent Company] Combo box, then the [GID] text box
automatically fills in the GID number off the [Company Names] Table. I'm
guessing this will need to have a Dlookup function, but what would the
equation be.

I hope this makes sense.
.

Relevant Pages

  • Re: lookup value on form in a table
    ... > automatically fills in the GID number off the Table. ... so change the following to match the name of the controls on your form. ... need to post what is in the Row Source of Parent Company and what the bound ... I'm assuming the Row Source is SELECT GID, ...
    (microsoft.public.access.forms)
  • Re: Opinions on Nova DVR XP
    ... Nased on the current feedback and the previous string of posts in March I put in an order at the local Woodcraft and should have it in about 2weeks. ... The primary use would be turning of bowls, ... Any rumors about the financial health of the parent company? ... The computer did go bonkers once, but all it took was to unplug it for 5 minutes for a hard reboot and everything has been ok since then. ...
    (rec.crafts.woodturning)
  • Yay! Im back!
    ... Dear Gid, thanks, I think I have set this up right and it all appears to be ... I had to "catch up" as there were squillions of posts, ... Jackdaw ...
    (uk.religion.pagan)