Updating/Refreshing Form Data

  • Thread starter Thread starter Brook
  • Start date Start date
B

Brook

Good Afternoon,

I am using two forms to populate data into one table.
The first form allows the user to perform a lookup on a
Company Name and populate 3 fields used in formII. I have
a button that takes me from form1 to formII based on the
Record ID it takes me to the Detailed information from
FormI. When I go to the details of the record in In FormII
the infomormation is not populated, however If I go to the
details of another record then back to my last record that
wasn't showing the information, the information is now
populated. Does anyone have any ideas how I can perform a
Table/Record update/refresh so when I go to my FormII
details my information is populated?

Thanks,

brook
 
Brook said:
Good Afternoon,

I am using two forms to populate data into one table.
The first form allows the user to perform a lookup on a
Company Name and populate 3 fields used in formII. I have
a button that takes me from form1 to formII based on the
Record ID it takes me to the Detailed information from
FormI. When I go to the details of the record in In FormII
the infomormation is not populated, however If I go to the
details of another record then back to my last record that
wasn't showing the information, the information is now
populated. Does anyone have any ideas how I can perform a
Table/Record update/refresh so when I go to my FormII
details my information is populated?

Thanks,

brook
Click to expand...

In the button that takes you to "Form II", force the current record to
be saved before you execute the OpenForm statement. Here's code to
insert:

If Me.Dirty Then
RunCommand acCmdSaveRecord
End If
 
Brook said:
What would the Me.Dirty be refrencing? My table?
Click to expand...

"Dirty" is the name of a property of the form, the form itself being
referred to here by the keyword "Me". A form's Dirty property has the
value True if the form's record has been modified but not yet saved,
False if not.
 
Back
Top