Limited list combo (previous combo select), doesn't allow selection 1

[Aurillius]

Hi there,
I have a database with an "error" table. Two fields lookup muliple values to their corresponding linked tables.

Combo Box1-> tblError1 = ID; Type
Combo Box2-> tblError2 = ID; Type; Description

Essentially, I've managed to get the query working on Combo Box2 "afterupdate" on Combo Box1 but I have 2 problems:

- Combo Box2 shows proper results based on Combo Box1 but always defaults to the first query result after selection
- Form is a continuous record entry...all previous records on the form limit their selection to the results on the entry line selection.
HELP!!
Aurillius

 

[dhookom]

Please share the Row Sources of the combo box as well as any code or macro in the After Update.

You must understand that a control in a continuous form shares all properties with every record in the form (other than conditional formatting). Changing the Row Source in on combo box affects this combo box for every record in the form.

Duane
Hook'D on Access
MS Access MVP

 

[Aurillius]

Hi Duane,
I fixed the query issue; I didn't reference the ErrorDesc.ID in my query as it is the relationship:

Fixed:
SELECT DISTINCTROW ErrorDesc.ID, ErrorDesc.Desc
FROM ErrorDesc
WHERE (((ErrorDesc.Type) Like [forms]![Rec Dec 2010]![Error1]));

It's unfortunate that I can't query the current record though, I guess a workaround would be to make my form, a subform with previous entries bound to the main form (requery after each entry)...would this work??
Mark

 

[dhookom]

I typically don't filter the second combo box if it is dependent on a value from the row/record. I set the order of the records in the second combo box to place the unacceptable records at the bottom and add a column that suggests "DO NOT SELECT".

Duane
Hook'D on Access
MS Access MVP