form refresh

  • Thread starter Thread starter Jason Frazer
  • Start date Start date
J

Jason Frazer

I have a form that references 2 tables. The form has 2
tabs. The first tab [tab1] references [table1] and the
second tab [tab2] references [table2]. If tab2 is clicked
on I want to copy structure number (8) from [tab1] to
bridge number on [tab2]. This works but it does not show
the bridge number until you change records. How can i
refresh the form. Here is what i have so far.

Thanks for your help Jason

Forms![Bridge Inspection Form].Form![Bridge Number] =
Forms![Bridge Inspection Form].Form![Structure Number (8)]
DoCmd.RunCommand acCmdSaveRecord
 
Jason Frazer said:
I have a form that references 2 tables. The form has 2
tabs. The first tab [tab1] references [table1] and the
second tab [tab2] references [table2]. If tab2 is clicked
on I want to copy structure number (8) from [tab1] to
bridge number on [tab2]. This works but it does not show
the bridge number until you change records. How can i
refresh the form. Here is what i have so far.

Thanks for your help Jason

Forms![Bridge Inspection Form].Form![Bridge Number] =
Forms![Bridge Inspection Form].Form![Structure Number (8)]
DoCmd.RunCommand acCmdSaveRecord
Click to expand...
me.refresh
 
Back
Top