The normal route would be a pop up single form that is opened modally/dialog on top the of the main list, and then returns you to where you where after is opened.
I have lots of them but they are are proprietary to the clients app, and difficult to take pictures of without munging a ton of the data.
I normally use a double click event on the Job_Number/Contract/Client_ID and pass it to the pop up with the OpenArgs property, then set the pop form to the appropriate single record.
Thats all fine thanks for the help, I think I can find a way to implement this. But I was wondering after updating that single record have you been able to reflect that change on the original table instantly. Or does the original table have the old info?
Thats all fine thanks for the help, I think I can find a way to implement this. But I was wondering after updating that single record have you been able to reflect that change on the original table instantly. Or does the original table have the old info?
Once you have saved the change(s) to a record, they are in the table. To see the change(s) in a form, though, you need to requery or refresh that form's recordsource.
Once you have saved the change(s) to a record, they are in the table. To see the change(s) in a form, though, you need to requery or refresh that form's recordsource.
If you requery the Recordset not the form it will normally stay put where it was. (An often overlooked method)
If not simply store the unique ID before opening the edit form, then requery, then use the rs.bookmark and find first method to get you back where you were.
If you requery the Recordset not the form it will normally stay put where it was. (An often overlooked method)
If not simply store the unique ID before opening the edit form, then requery, then use the rs.bookmark and find first method to get you back where you were.
@GPGeorge
Where you have a Me.Requery or any form requery, just insert Recordset eg: Me.Recordset.Requery
Hard to give you a working example, but here is code from my old SSAFA DB
In fact I just added the recordset, as it was not there before.
Code:
Private Sub cmdRequery_Click()
Dim lngID As Long
Dim rst As DAO.Recordset
Dim strCriteria As String
' Save record so requery on subform will pick up all last record written
If Me.Dirty Then Me.Dirty = False
lngID = Me.ID
Me.Recordset.Requery
strCriteria = "ID=" & lngID
Set rst = Me.sfrmEmails.Form.Recordset
' Requery the subform
Me.sfrmEmails.Form.Recordset.Requery
' Go back to record we were on
Me.Recordset.FindFirst strCriteria
' Now the sub form
rst.FindFirst strCriteria
Set rst = Nothing
End Sub
so really the FindFirst is no longer needed.
Code:
' Go back to record we were on
'Me.Recordset.FindFirst strCriteria
' Now the sub form
'rst.FindFirst strCriteria
Set rst = Nothing
@GPGeorge
Where you have a Me.Requery or any form requery, just insert RecordSouce eg: Me.Recordset.Requery
Hard to give you a working example, but here is code from my old SSAFA DB
In fact I just added the recordset, as it was not there before.
Code:
Private Sub cmdRequery_Click()
Dim lngID As Long
Dim rst As DAO.Recordset
Dim strCriteria As String
' Save record so requery on subform will pick up all last record written
If Me.Dirty Then Me.Dirty = False
lngID = Me.ID
Me.Recordset.Requery
strCriteria = "ID=" & lngID
Set rst = Me.sfrmEmails.Form.Recordset
' Requery the subform
Me.sfrmEmails.Form.Recordset.Requery
' Go back to record we were on
Me.Recordset.FindFirst strCriteria
' Now the sub form
rst.FindFirst strCriteria
Set rst = Nothing
End Sub
so really the FindFirst is no longer needed.
Code:
' Go back to record we were on
'Me.Recordset.FindFirst strCriteria
' Now the sub form
'rst.FindFirst strCriteria
Set rst = Nothing
I don't have a link to the thread but I discovered a while back that hidden indexes created by Access on FK's do not get upsized. Only indexes that are manually created get upsized. No one was ever able to tell me whether or not having two indexes on the same field cause a problem for ACE, so since Access always creates hidden indexes and those don't get upsized, I'm not sure I want to create duplicate indexes in the ACE BE's. So, I don't crete the manual indexes until I'm ready to convert the BE. Then I create them in ACE and SSMA upsizes my indexes correctly.