How do i use a button to open a new form under a certain field?

[jessgreen167]

I am creating a database in Access 2013. I am trying to learn how to use a button to open a new form under a certain field. For example, I am creating a database for contracts. I have multiple contract numbers that have numerous line items under the one contract number. I have a form already created to add the contract information. How do I create a form to add a line item under the certain contract number that's been selected? I hope I'm asking this correctly!!

[ItsMe]

You can open forms using criteria. Here is an example that uses a string variable, strWhere. You build the criteria in the string variable and then reference the variable in your Docmd statement.

Dim strWhere As String
strWhere = "ContractNumberFieldName = " & Me.ContractNumberControlName
DoCmd.OpenForm "NameOfForm", acNormal, , strWhere

[jessgreen167]

Thank you ItsMe. Is this code? In order for this to be done should I know how to write code?

[ItsMe]

It is code. You would put it in an event handler. Maybe a click event for a button control. You would need to identify the field name and the control name so the code for the WHERE criteria will work. Also you would need to place the correct form name in the code. I edited my previous post so you can see the names that would need to be edited.