Updating?

Ringers

Registered User.
Local time
Today, 15:32
Joined
Mar 4, 2003
Messages
54
I have a form that has two combo boxes, some text fields, and a subform. I have managed to get the combo boxes to cascade and display the correct information. But their are two problems.

1. The combo boxes only filter the first choice made in combo box one. If you try to update the selections displayed in combo box 2, by making another selection in box 1 it won't update. It will still show the first choices. you have to shut down the form to update the second combo box.

2. This problem is very simliar to the first. How do i update the text fields and subform depending on the selections made in the combo boxes? I haven't got a clue on how to approach this.

It has taken me a lot work to get this far, so any help would be great.;)
 
Requery the second combo on the after update event of the first
 
2. You don't need to save the "looked up" fields. Base the form on a query that joins the main table to the "lookup" table. Then you can select columns from each table. When you select an item from the combo, Access will AUTOMATICALLY populate the bound columns. If you want to read more about this, search for autolookup queries in help and in this forum.
 

Users who are viewing this thread

Back
Top Bottom