requery problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to requery only the current record?

I have two cascading drop down menus. In the second dropdown I have a where
in the carrierid section ("[Forms].[PackageInfo].[cboCarrier]"). It works
nicely, however I have noticed that when I have more than one record saved
the dropdown menu does not show the correct value(the correct value is saved
in the table). It is not showing the correct value because the list only
shows the last carrierID from the last updated record.

For example if I have fedex on one record and then go to another record and
select ups. when I go back to the fedex record the 2nd dropdown box only
shows ups services (not fexed like it should), so the stored value can't show
it in the list.

How do you only update the current records 2nd combo with the requery
technique, so when you go to other records it does not change the 2nd drop
down list?
 
James said:
Is there a way to requery only the current record?

I have two cascading drop down menus. In the second dropdown I have a where
in the carrierid section ("[Forms].[PackageInfo].[cboCarrier]"). It works
nicely, however I have noticed that when I have more than one record saved
the dropdown menu does not show the correct value(the correct value is saved
in the table). It is not showing the correct value because the list only
shows the last carrierID from the last updated record.

For example if I have fedex on one record and then go to another record and
select ups. when I go back to the fedex record the 2nd dropdown box only
shows ups services (not fexed like it should), so the stored value can't show
it in the list.

How do you only update the current records 2nd combo with the requery
technique, so when you go to other records it does not change the 2nd drop
down list?
Click to expand...


This issue has nothing to do with requerying anything. The
effect you seeing is because there is only one combo box on
the form, it's just being displayed multiple times when the
form is displayed in Continuous or Sheet view.

There is a way to get this to look the way you want, but it
requires the form's record source to include the value that
you want displayed and binding that field to a text box
that's positioned directly on top of the text portion of the
combo box. The text box's GotFocus event then has to have a
line of code to (re)set the focus to the combo box, which
will automatically bring it to the front so the user can
interact with it in the usual way.
 
Back
Top