Re: Using Combo boxes

On Tue, 24 May 2005 11:59:01 -0700, "ivalum21"
<ivalum21@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>I have two tables...Classes and Rooms. I have a form where I can add new
>classes and assign it a room. The rooms never change, so I am using a combo
>box to assign the classes to a room. But when I add a new class and select
>a room from my combo box, it adds a new RoomID into my Rooms table along with
>adding my new class.
>
>How do I JUST add the class, and use the Room table without updating it??

Base the Form on your Classes table, not joining the Room table to it;
the Room field should be updated using a combo box based on Rooms, but
you needn't include the Rooms table on the form's recordsource in
order to do this!

John W. Vinson[MVP]
.

Relevant Pages
Loading