Need Serious help- form due tommorrw for Client!!

[dakcg]

Greetings All,

I have a feeling that my problem is easy, but I have been in a panic over this project, that I cant think too straight anymore (I think I need a vacation!)

I have a simple form for tracking employee activity, such as rehire, death, orig hire, exc. This works find, except they now want to be able to make changes to staff details like new job title and such. On the same form. They don't want to change forms.

So I added a subform that connects to the Staff Detail table, using the Clock# that exists in both tables.

When the form is open, user must choose employee from drop down, once choice is made the clockno on the main form fills in, however, the subform clockno which it connected to the main doesnot update- unless, is you go into design view and then back to form view, the subform fills in with the right info, you can even use it in quierys -- However, if you change the employee in the main form, its clockno will change, but not the subform, you have to go the design view again. I have no clue. HELP

 

[adaniele]

dakcg, basic question...did you checked the child and master link fields ?
max.

 

[dakcg]

Yes, first thing I did, I even recreated the subform several times, same proplem Help

 

[RuralGuy]

As a test, put a Me.SubformControlName.Form.Requery in the AfterUpdate event of the ComboBox. Replace SubFormControlName with your SubFormControlName.

 

[dakcg]

Thank you, Thank you, Thank you. That work perfectly.

 

[RuralGuy]

You're welcome but I believe that verifies that the "Link Master/Child Fields" are not set up properly. You should *not* need the requery.

At least they are *not* functioning as they should and that will probably come back to bite you some day unless it is fixed.

 

[dakcg]

Thanks for the heads up, i will look at them again. Luckily, client postponed until Monday, giving me some room to breath, thanks again