I'm working in Access 97. I have 4 forms set up using the tab control. I have a field named Report# on each of these forms, from the same table. When I key a number into the field in the 1st form, the other 3 forms will not update the field entry, unless I close the forms and open them back up. What can I do to update these 3 forms after I have made entries on the first.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Update a field in open forms
- Thread starter lucybelle
- Start date
Zeroanarchy
Technical User
the feild you key the number into
Private Sub report_AfterUpdate()
Forms!form2.Refresh
Forms!form3.Refresh
Forms!form4.Refresh
Hope this helps.
ow forgot to mention on each of the forms the report field need to have a control source of:
=[Forms]![Form1]![report]
on each of the forms add a new field: and have the
default value = the field being updated.
and a control source of where ever you want it to go in the table. Then remve the tab stops of the new field and make it invisible.
good luck
Zero
Private Sub report_AfterUpdate()
Forms!form2.Refresh
Forms!form3.Refresh
Forms!form4.Refresh
Hope this helps.
ow forgot to mention on each of the forms the report field need to have a control source of:
=[Forms]![Form1]![report]
on each of the forms add a new field: and have the
default value = the field being updated.
and a control source of where ever you want it to go in the table. Then remve the tab stops of the new field and make it invisible.
good luck
Zero
- Status
Similar threads
- Locked
- Question
