Noob needs help with form design

[ItsMe]

After you get the suggestions in post #15 implemented, I suggest you pause and revisit your relations. I did not look at your DB but I sense a need for an additional table.



I am going to guess a single rider, that enters a single event, may want to enter multiple classes. There are several approaches to manage these relations. Bear in mind, you can use VBA to update tables. It is not mandatory to bind all controls on a form (like June mentioned, use your bound form to update one table). For instance, you may deem it beneficial to bind the Rider Combo and not bind the Class combo, using VBA to update a record with Class data in a table not part of the form's recordset.

[Motoman]

WAHOO!

It works

Following your lead on the Riders combo box I was able to get the Class combo box to work, and lo and behold the thing started putting records in the Entries table. Crazy!

I'm gonna play with this for a while now...this might be just about all the functionality I need to make this tiny little application work. June, you are now officially my favorite month

[Motoman]

Yeah, a rider will enter multiple classes...but it looks like (as painfully simplistic as this example is), it's already doing that. I can put Bubba in a class, and then select him again and put him in another class.

If I get fancy with it I'll have to figure out how to make sure I don't redundantly put Bubba in the same class twice. I might be catching on to the various properties of things...at any rate, I'm going to spend some time playing with it now and see what else I can break

Since post #15 got my original inquiry answered - having the combo box control the data shown in other fields - I'm gonna mark this as solved and then open a new thread if I run into something else.