Show specific record in a form launched from a subform using the same table and recor

[tmedzyk]

I have a form with a sub form. The sub form is in datasheet so they can see each record. The data sheet view only allows them to see a snipit of what is in the field because it is a memo field. As they enter the data they really need the field bigger so they can see what they are entering. Also once it is entered they need to be able to go back and see what they entered.

I have:

Private Sub MemoField_Click()

Dim frm1 As String

frm1 = "frm_PopUpForm"

DoCmd.OpenForm frm1
Forms!frm_PopUpForm.caseno.Value = Forms!frm_DataEntry.caseno
Forms!frm_PopUpForm.MemoField.SetFocus


When they click on the field a pop up form opens and enters the child field from the parent form. This pop up form shows just that field in Form view with the field several inches wide and high allowing them to see more of the field as they are typing or view it once it is entered.

My Problem:
Once they enter one record and click in the next records field to enter another record the pop up form opens to the first record and shows them the data in the first record not a blank field to enter the new data. Which means if they do enter two records and want to go back over what they entered, clicking the second record brings up the first record not the one they want to see.

They can use the navigation buttons to add a new record or move to the second record but my users are not very skilled and would do better with the pop up form opening to the correct record.

Any thoughts?

 

[John Big Booty]

You could use the Where condition of the OpenForm method to open the form filtered to the current record.

Or perhaps the solution presented in this sample is more along the lines of what you were looking for.

 

[tmedzyk]

Zoombox! Awesome that did the trick. Thank you so much