Command Button On Each Row Of A Continuous Form?

[Ayiramala]

Hi,


This is what I have done: There is a continuous form with a check box in each row and a command button(cmdDetails) in the form footer section. You select a record and press cmdDetails and another form opens.

Rather than in the footer, I would like to have the command button placed in the details section itself, in each row, against each record, so that the check box can be eliminated. Pressing any button will open the corresponding form.

Could some one please help me with this? I have the least idea how I can "associate" each record with the button next to it.

Thanks.

[ItsMe]

I don't use continuous forms very often. But, you should be able to do what you want.

While in Design View of your form, add a Command Button to the detail section. Add some VBA behinf the new control by going to the property sheet. Under the Event tab, click on the elipses(...) to the right of the On Click event. Click on Code Builder and then click OK.


The VBA editor will open. There will be a new sub procedure created for the click event. Just above the line that says End Sub place your VBA. Here is an example. You will need to change the FormName, FieldName, and Control Name to match your DB

DoCmd.OpenForm "FormName", , , "FieldName = " & Me.[ControlName]

[Ayiramala]

That worked! Thank you very much. May I ask just one more thing?

Depending on whether frmDetails is empty or not, can we apply some conditional formatting to the command button? For example, if frmDetails is empty, the button is blue, otherwise it is red?

Again, thank you very much for your help.

[Ayiramala]

Kindly ignore the previous post.. Learned how to do it with a text box instead.

Thanks for all the help. Much appreciated.