Continuous Form Issue

[lsgKelly]

I have a continuous form that has information. Within that continuous form,
there is a field called "tname". On that field, I have the following code:

Me!TierID.Requery

This requeries a dropdown in the header section of the field, based on
information for that field. Example: if the field has N in it, the only the
records with N show up in the dropdown. If the field has S, then it only
shows records with the S.

This is working great. However, what I would like to happen is after they
update that field, it goes to the next record, selects the tName field, so
that the TierID field is again requeried.

So far, I have it so that it goes to the next record...with this code:

DoCmd.GoToRecord , , acNext
Me!tName.SetFocus
Me!TierID.Requery
Me!tName.SetFocus

I'm trying to get it to go to the next record, go to the tName field, and
requery the TierID field.

It's not working. It goes to the next record, but doesn't go to the tName
field or requery the Tier ID field.

Help? and Thanks!

Kelly

 

[BruceM]

Tables and queries have fields. Forms and reports have controls. You can
requery a control, which it sounds like you are doing, but it is hard to
know what you mean by the header section of a field. If you mean you have a
combo box in the form's header section, could you just requery it in the
form's Current event? If so, you could set the focus to the appropriate
control at the same time.