Re: [MS_AccessPros] Subform

 

Dennis-

Then that control needs to be a combo box.  

Row Source:  SELECT Produktnr, Produkt FROM Produkts ORDER BY Product;

Column Count: 2

Bound Column: 1

Column Widths: 0; 1.5

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Oct 20, 2014, at 4:25 PM, Dennis Davidsson dennisdavidsson@ymail.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

John,

the field Produkt is text, that is correct, but the control is bound on Produktnr which is an auto number, i.e. the primary key of the table Produkter.

Dennis

__._,_.___

---

Posted by: John Viescas <johnv@msn.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (38)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___