forms

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

Guest

i have a form called Form1 in it a subform Pairs which i update using command
buttons to open other forms for editing . When i close the editing form the
subform update ok but i have textboxes that may have "Allocated" or " Faulty"
in them if Faulty the box should turn red. the only way i can get the colour
change to occur is by going to the next record and then back.

i have tried requery, repaint but i may have the wrong syntax

can anyone help

Ta
 
Arnie said:
i have a form called Form1 in it a subform Pairs which i update using command
buttons to open other forms for editing . When i close the editing form the
subform update ok but i have textboxes that may have "Allocated" or " Faulty"
in them if Faulty the box should turn red. the only way i can get the colour
change to occur is by going to the next record and then back.

i have tried requery, repaint but i may have the wrong syntax
Click to expand...


How are you setting the color?

I think if you use Conditional Formatting, it should work.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subform based on external SQL won't requery 1
SubForm Footer wont reload fast enough 4
Refresh data in sub forms when one sub form is edited 4
refresh/requery subform 2
Problem refreshing child form 1
Error removing last record from subform 1
CheckBox in PopUp form grayed out 5
Subform won't requery ONLY for the FIRST record added/deleted/edit 11

Back
Top