Option Group Problems 1

[cpc101]

I have a data entry form that folks will use to enter data from our manual
inventory count. I have an option group that when an item in that group is
selected, it will only allow a certain range of part numbers to be
available.

The problem I'm having is, if I should select an incorrect option, selecting
the correct option does not requery the input field.

Siplified:

Select the class. (Finished Goods, Raw Material, etc.) Will only allow you
to select part numbers that reflect Finished goods or Raw Materials. If I
select FG, it will display only FG, However if I select RM it still only
displays FG.

I hope this makes sense.

 

[dhookom]

Is there a combo box involved in this issue? If so, what is the Row Source and how is it updated?

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cpc101]

Yes there is a combo box...

The row source is

SELECT [Item Master.Item] FROM [Item Master] WHERE [Item Master.Class]=[Forms]![Tag Entry All Locations]![Class];

The Option group is

AfterUpdate

Private Sub Class_AfterUpdate()
Me.Class.Requery
End Sub

Does the Combo need to have something in AfterUpdate also?

 

[dhookom]

You need to requery the combo box in both the after update event of the option group and in the On Current event of the form. You don't need to update the option group control.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cpc101]

So then for the form 'oncurrent' I would have...

Me.formname.requery
Me.Combobox.Requery
or
Me.optiongrout.requery?

Thanks a heap for your help!

 

[dhookom]

I don't see any reason to requery the form or option group. As I stated previously, requery the combo box control.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[cpc101]

I got it thanks!!!!

I just had to re-read your response...


Huzzah!!!!