Open another form from a subform...

[DaveWms]

I know this has been addressed on this and other forums, but I don't completely understand the lingo.

I have a database with two tables, two forms, and one subform.

I have a 'form1' with 'subform' which shows the records from 'form2'. (The subform only shows

I want to click a record in the subform, and have the form it's based on (form2) open to the record I clicked on in the subform.

Can anyone explain how to do this in a low tech format? (I know just enough to really mess something up, but I'm the only one here that can turn on a PC.)

[June7]

Code behind the subform, can be form Click or DblClick event. Something like:

DoCmd.OpenForm "Form2", , , "ID=" & Me.ID

[thebigthing313]

Why do you need to open Form2 separately when Form2 is already displayed in Form1 in the Subform control?

[June7]

big, I think there are 3 forms - Form1 and subform then also Form2. OP wants to open Form2. Although could be wrong, I initially had the same question as you.

[thebigthing313]

Ah, ok. I thought he meant 2 forms, one of which is used as a subform. Carry on

[DaveWms]

Why do you need to open Form2 separately when Form2 is already displayed in Form1 in the Subform control?

There is a whole page of data for each record in Form2 (too much to view in the Subform's datasheet view). The Subform shows just enough of each record to know which one we need (and there can be many records).

[DaveWms]

I open Form1 (name and address of customer), and the Subform shows a single line representation of each invoice (with invoice number, and date). (Subform is in Form1.)

From there we want to click on the target invoice number to open Form2 to see the complete invoice; What we did, if it's in warranty, who was the tech, etc.

I know the basics, but don't know how to do the particulars.

Thanks for any input.

[June7]

Did you try suggestion in post 2?

[DaveWms]

I tried, but I'm not real sure where it goes (I'm in learning stage). VBA, SQL, Macro, Expression builder... I'm lost.

(I'm glad I was working on a copy because I fouled up the form.)

I tried a variation, and got an error saying something like 'can't change focus to _____'.

[June7]

I suggested VBA code. There is macro equivalent.

Select button in form design view. On Property Sheet event tab select [Event Procedure] in the Click event property then click the ellipsis (...) to open the VBA editor and type code into procedure.

[DaveWms]

Thanks... I'll try it when I get back to the office.

[DaveWms]

A question... "the VBA editor" is which of these: Macro Builder, Expression Builder, or Code Builder?

I think it's the "Code Builder" but I'm just not sure.

In the line: DoCmd.OpenForm "Form2", , , "ID=" & Me.ID is "Form2" the only thing I change to it's real name? Do I retain the quotes?

Sorry I'm causing you to explain at a kindergarten level!

Thanks for your help.

[DaveWms]

This is what I put in the Subform cell's "On Click" property:

Private Sub InvoiceNumber_Click()
DoCmd.OpenForm "Invoices", , , "ID=" & Me.ID
End Sub


I got this message:
Compile Error
Method or data member not found.

The debugger has .ID highlighted in "Me.ID"

[June7]

I used ID as an example. I don't know your database structure. Just as you used your actual form name, use your actual field names.

[DaveWms]

Still can't get it to work; I'm sure it's me.

I'm going to back off a bit, then get back at it again.

Thanks for all the help.