two forms help

  • Thread starter Thread starter Emma Bielawski
  • Start date Start date
E

Emma Bielawski

Hi ,

I hope someone can help.

Background.
I have a company form that I don't want to be editable, so my frmcompany
doesn't allow entries.
I have an edit form where to info is modified.

Situation
Each company has a rating and I have a textbox called rating. There are
three conditions that change the forecolor of the textbox depending on a
character entered. The code is wriiten in the change event on the rating
textbox on the edit form.

Problem
When I close the edit form, the rating textbox on the frmcompany does not
reflect the color that is on the frmedit_company.

thanks in advance

Emma
 
Access 2000 or later, look at "Conditional Formatting"... then, if you
update, be sure to Requery the other form so the updated value shows. Your
code in the Change event, as you no doubt are aware, is executed only when
someone types into the Text Box -- so it is no surprise. If you Requery,
perhaps you might have better luck putting your code into the Activate event
(but my experience is that the Activate event doesn't always fire every time
I would have expected it to -- particularly when popup and modal forms are
involved).

Larry Linson
Microsoft Access MVP
 
Back
Top