requery changes record

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

Guest

I have a form that works with my CIRCUITQRY qry using tables CIRCUITt and
CABLEthat are linked by CABLEID
I have a field in the qry that is a concatenation of items in the cable
table called
CABLETYPE
I have a combo box that changes the CABLEID field for the circuit table.

When I change the CABLEID using the combo box I need the CABLETYPE to change.
I can do this with me.requery, but it takes the user back to the beginning
of the form. How can I keep it on the current record.

I appreciate any help with this I am stumped.
 
Make sure the form's Default View is set to Single Form.
Using Me.Requery requeries the whole data set.
Try cboCableID.Requery, or whatever field name you want to requery rather than Me.
 
I tried that it was another field, and I got an error message.
I want to thank you for the help on this. I finally took the field that
concatenates the items out of my query and fill in the form field through vb
when they change the combo box.
Thank you again
 
Back
Top