I am trying to create a Form which will have 3 Text boxes for Part Name, Part Description and Part Number. Also 1 Combo Box where it will grab the Values from Main Area in tblArea. My problem is that I do not want any data entry into the Area Table. I just want to use the Area table as a look up table. Maybe there is an easier way of doing this.
For example, View the items in Combo Box from Main Area, but when I update the record just record the corresponding AreaID in tblPart. I would also appreciate if anyone would tell me what the Form record source should be. Thanks.
From the sound of it, the form would be bound to tblPart. The combo would get its selections (its row source) from tblArea, but save the selected item to tblPart (its control source). The combo box wizard should walk you through it.