when i double click a field

[Guest]

When I double click a field i have a form opening up as read only as a pop up
but not modal.
i then want the pop up form to stay open, but be able to edit the field's
contents that opened the pop up form in the first place whilst keep the popup
open

When I move to a another record i want to have the pop up form close and
then re open on the basis of if there is associated record in the opo up
underlying table

 

[Allen Browne]

If you set the Popup property of this form to Yes, you can easily use the
DblClick event of your control to:
Private Sub Text51_DblClick(Cancel As Integer)
OpenForm "Form1"
End Sub

To close it when your form moves record, use the Current event of the form:
Private Sub Form_Current()
If CurrentProject.AllForms("Form1").IsLoaded Then
DoCmd.Close acForm "Form1"
End If
End Sub

Note that this will NOT work well if both forms are bound to the same table,
as you will get concurrency errors--"You and another user are trying to
change the same data at the same time", a conflict dialog, or locking
errors.

 

[Guest]

thanks


how do i unsrue that the popup form appears at precisely the same
coordiantes on the screen each time

 

[Allen Browne]

Not sure if this link will be any use:
http://www.lebans.com/openform.htm

If not, ask it as a new question.

 

[Guest]

looks good enough
--
Regards


Patrick Stubbin

Not sure if this link will be any use:
http://www.lebans.com/openform.htm

If not, ask it as a new question.