Edit a selected record in subform using form

[joshi868b]

I have a subform which shows the list of record .primary key is not assigned.i want to select a record from subform and want to click on a button called edit.it should open the form with the selected details.thanks in advance . suppose the subform name is" portdetails subform" and filed are l2 ip address, vlan ,mac address,name ,ser no,dn no,.can i attach the database here in this forum .

 

[arnelgp]

best to put AutoNumber field in the underlying table of your subform. so you can refer to it on the clicke event of edit button.

private sub editButton_click()
docmd.openform "formname", acNormal,,"[autonumberfield]=" & me.[autonumberfield]
end sub

 

[RuralGuy]

I believe you need at least 10 posts before you can upload files. Is the subform in continuous view or data sheet view? Why don't you have a Primary Key (PK) for this table?

 

[joshi868b]

DEAR RURAL GUY,
IT IS A DATA SHEET VIEW. And there is not any suitable field to choose a s primary key

 

[RuralGuy]

Which is why "arnelgp" recommended adding an AutoNumber field (PK) to the table. Those PKs can come in real handy sometimes and all it costs you is a little disk space. Is there anything in that table record that makes it unique?

 

[joshi868b]

this is table of different field like mac address (unique). but all the records does not have the mac address some have blank filed .

 

[RuralGuy]

Since mac addresses are unique in the world, you should be able to open a form just showing that record. You can use the click event of the mac address field to open the form: http://www.baldyweb.com/wherecondition.htm

 

[jdraw]

You can attach your database without 10 posts - if you use zip format.

 

[RuralGuy]

Thanks jdraw! See, I learn something new every day.

 

[joshi868b]

IN THE ATTACHED DATABASE WHEN I OPEN THE FORM "FORM1" AND SELECT ANY RECORD FROM THE SUBFORM AND CLICK THE EDIT BUTTON. IT SHOULD OPEN THE FORM "editfrm" WITH THE SELECTED RECORD SO THAT FURTHER I CAN UPDATE THE DETAILS.

 

[RuralGuy]

I'll be honest, using ALL CAPS is called SHOUTING on the internet. Thanks.

 

[joshi868b]

sorry brother

 

[RuralGuy]

What version of Access are you using?

 

[joshi868b]

I am using ms access 2007

 

[RuralGuy]

Thanks! It looks pretty straight forward to fix. Give me a minute.

 

[jdraw]

Every table should have a primary key.

I selected a record on the subform and was able to edit and save the address change I made???

You might want to review this youtube series by Steve Bishop for some programming techniques/examples.

 

[RuralGuy]

Change the procedure code under the Edit button to:

Private Sub Command15_Click()
     DoCmd.OpenForm "editfrm", , , "id =" & [Table1 subform].Form.ID
End Sub

 

[RuralGuy]

The Sample submitted has an AutoNumber PK field. Pretty easy to solve.

 

[joshi868b]

It Is not working. can u attach the sample with solution please

 

[joshi868b]

still waiting for your solution please