Hi everyone.
I made a tabular form to show some data and image for each record. the problem is i cannot make that image for each record is different. what happens is: all records images are the same. when i move to next record all images are changed to the right one. I would prefer images to be linked not embedded. everything works ok if i use columnal form. but for tabular form each images instead of being linked to different sourses, they all linked to the one source (the one that correspondents to the active record). the code i use is:
Private Sub Form_Current()
On Error GoTo emptypic
Me![Image18].Picture = "C:\images\" & Me![someid].Value & ".jpg"
Exit Sub
emptypic:
Me![Image18].Picture = ""
End Sub
Private Sub someid_AfterUpdate()
On Error GoTo emptypic
Me![Image18].Picture = "C:\images\" & Me![someid].Value & ".jpg"
Exit Sub
emptypic:
Me![Image18].Picture = ""
End Sub
thanks in advance.
I made a tabular form to show some data and image for each record. the problem is i cannot make that image for each record is different. what happens is: all records images are the same. when i move to next record all images are changed to the right one. I would prefer images to be linked not embedded. everything works ok if i use columnal form. but for tabular form each images instead of being linked to different sourses, they all linked to the one source (the one that correspondents to the active record). the code i use is:
Private Sub Form_Current()
On Error GoTo emptypic
Me![Image18].Picture = "C:\images\" & Me![someid].Value & ".jpg"
Exit Sub
emptypic:
Me![Image18].Picture = ""
End Sub
Private Sub someid_AfterUpdate()
On Error GoTo emptypic
Me![Image18].Picture = "C:\images\" & Me![someid].Value & ".jpg"
Exit Sub
emptypic:
Me![Image18].Picture = ""
End Sub
thanks in advance.