Subform record!

[pgp]

Hi,

In relation to my previous posts,

Right now, when I double click a record in my subform, it opens a new form without any values being populated.

I tried creating a query to see if that can select the record Im trying to populate in my new form

DoCmd.OpenForm "ChangeNomexQuote", , , " LineItem = " & Me.Text18
MsgBox "opening"
DoCmd.OpenQuery ("ChangeQuoteUpdate")
Forms.Item("[ChangeNomexQuote]").Requery

Using the above query, when I double click the record in a subform, it opens the full record , but in a datasheet view. I want this record to be updated in the fields in the form instead of datasheet view.

How do I do it?
Thanks in advance

 

[jonifen]

go to design view of the form you want to open, and change the properties to only load in form view rather than datasheet or both.

that should sort it.

I'm interested by your idea though... its something I want to do myself.
I have a subform which is a datasheet with records in. When I double click on one of the records in this datasheet, I want it to open a new window with a form showing all the information in form view. Would your code do this for me?

edit: sheeesh - just noticed how old the original post was... still though... can anyone help with my problem? Would the above code work?

another edit: nps about the reply. I figured it out. Managed to get my words right in the search field to get something up

Leaving post here to answer the last guys request though (incase he comes back... 1year after posting!!)