access training course - Subforms

Resolved · Low Priority · Version Standard

Tue 21 Aug 2007, 15:00 Delegate Jenny said...

Jenny has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Subforms

I have a main form (customer) which has a sub form (PetSubform). A customer can have one or more pets and the PetId, pet name and breed is shown in the subform.

I would like to double click on a row in the subform and open a form which shows all the fields related to that pet.

I can double click and get a form to open, but i need the form to open and display the right info based on the PetID.

Is there a way to select the PetId in just the selected row in the sub report and then open the form based on the petid in the selected sub report row.

Wed 17 Oct 2007, 12:46 Trainer Richard said...

RE: Subforms

I suggest that you use a command button to activate the form. When you draw a command button on the PETSubform, follow the wizard to:

1. Open the pet form
2. Select the value you want
3. Link the fields together

Once this is done, you can see the code behind the button, on the CLICK Event.

I would suggest that rather than using a DATASHEET view, use a CONTINOUS FORM VIEW, and have a button appear next to each record.
Arrange the fields to that it looks like a datasheet.

This will get you started in the right direction.

Let me know how you do.

Richard

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Access tip:

Create a custom Close button on a Form

By default, Forms that you create in Access have a full set of control buttons, that is, a title bar with Minimize, Maximize and Close buttons in the top right-hand corner and a Control Menu in the top left-hand corner.

Sometimes Access needs to follow certain procedures or events as users close a Form (such as automatically opening another Form perhaps). So it is often a good habit to create a custom Close button on a Form for everyone to use, rather than the standard closing cross.

To create a custom Close button:

1) In Form Design View, draw a Command Button onto the Form.

2) Use the Command Button Wizard to select Form Operations under Categories, and Close Form under Actions.

3) Choose Finish.

Access then creates the button and code to close the form for you. You can add any extra code that needs to run as the Form closes to the same Close procedure.

However, the creation of a custom Close button is pointless if the closing X in the top right-hand corner of the Form remains active. To make the closing X inactive, open the Form Properties box then on the Format tab set the Close Button setting to No. This will grey out the closing X leaving it visible, but inactive.