Form fields

[Peter Simpson]

I have a lookup form where I enter a lookup value, Let us say 16, from a combo box

On entering 16, 7 other text boxes populate showing me the information I need to see.

The problem I have is one of the fields is SupplierID_Fk which is a number representation of 7. I would like to see the supplier's name instead of the foreign key number. Can I insert another text box that links the FK to the Supplier table to show the supplier name?

[CJ_London]

suggest change the textbox to a combobox and populate the rowsource with the fields you want to display. Otherwise you can change the textbox control source to a dlookup (but then it will not be updateable, if that matters)

[Missinglinq]

Here's a short explanation of this approach:

http://www.baldyweb.com/Autofill.htm

Linq ;0)>

[pbaldy]

Here's a shorty explanation of this approach:

Shorty?!? Who you calling shorty?

[Missinglinq]

Well...at least I didn't call you 'baldy!'

Linq ;0)>

[pbaldy]

Sadly, that nickname is more and more appropriate.

[Micron]

Seems the controls are bound so a combo seems risky to me. If a fk is involved then likely a query is behind the form, populating 7 controls after a combo value is chosen. Then why not just add the missing field, or replace the fk field altogether. Possibly I'm missing the point when I say that I don't get why one would use a combo to simply display a missing field.

[Missinglinq]

Sadly, that nickname is more and more appropriate.

You and me, both! I'm 3 inches shorter, than when I graduated from high school, and that 3 inches apparently has moved into my forehead...shoving my hairline that much further back!

Micron...on rereading the OP, not really sure what he's asking...whether he's already using a Combobox to populate these fields, with all of them being in the Combobox' source, or whether he's retrieving an existing Record using it, and only wants the supplier's name to appear in the cbo, instead of the SupplierID_Fk.

Of course, it would probably help if the OP would respond to our posts.

Linq ;0)>