Experts Exchange connects you with the people and services you need so you can get back to work.

Open subform based on current record

Morning Everyone,

Can someone offer some guidance here?

I have a primary form and a subform already created. I want to place a command button into the detail of the primary form to open a subfrom based on the current record.

I assume I am going to use the Open Form method to accomplish this, however I am having difficulty understanding how to create the WHERE statement.

Both forms are based on primary keys using the same data "Item_Nr".

Form One details "item_Nr" and other information based on header selection

Form two details "Item_Nr" and other information based on a query from numerous tables.

Thanks for any help offered!

MC

MCaliebe

Asked: 2012-12-27

Advertise Here

Microsoft Access

1 Solution

LVL 61

mbizupCommented: 2012-12-27

By 'subform' do you mean a true subform which is embedded in your main form? or is it a separate popup form?

If it is the latter, you would use code similar to this from Form 1:

Docmd.OpenForm "Form 2", WhereCondition := "Item_Nr = " & Me.[Item_Nr]

Open in new window

That assumes that Item_Nr is numeric. If it is text, the code would be:

Docmd.OpenForm "Form 2", WhereCondition := "Item_Nr = '" & Me.[Item_Nr] & "'"

Open in new window

MCaliebeAuthor Commented: 2012-12-27

It was indeed text. Thank you for showing the differences. This goes a long way as simple reference when trying to understand formatting.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Open subform based on current record

Join & Write a Comment Already a member? Login.

Featured Post