I have a form and when the user enter a number into atext box i want the related data (displayed in a subform to be updated) - As it is now, when i change the number in the text box i have to click somewhere within the subform before it will change - i know i prob need to use the code builder but im not quite sure what to code - does anyone have any ideas?!
Assuming that both input/text controls have inderlying table fields.
Open main form in design view.
Open 'Properties' dialog box for the subform.
Click on 'Data' tab.
You'll see 'Link Child Field' and belove 'Link Master Field' lines.
Put the curson in one of them and click on three dots '...' on the right.
'Subform Field Linker' dialog box should pop up. In it you can choose which controls you want to be updated automatically after that contol looses focus.
jeez thanxs for all the effort you went to!!
Still having problems though cos when i click on the three dots im getting - the expression you entered refers to an object that is closed or doesnt exist - Im going mad with this!!! Have you any other ideas?!!!!