Displaying related record in the form

[maks_prince]

Hi am creating a program using Ms Access. I have a form called Invoice form. I is looks as per attachment without the dialog box. I would like to view the mileages record related to the invoice form. So when i click on the display button i would like to see the dialog box having the records. I have created a query called mileages which can allow you to view the record using the vehicle no. as parameter. The only problem is that is don't what to do so that when i click on display the record displays on the blank area. I also attaching the query i created.

 

[Big Pat]

Hi,
Are you happy that the query is giving you the results you want? If so, then you need to create a new form based on that query (Form wizard > select your query).

Then make your new button display that form. Or use your new form as a subform on your main form.

 

[maks_prince]

Thanks but this is not the way want it... I have tried this...

 

[vbaInet]

Hi,
Are you happy that the query is giving you the results you want? If so, then you need to create a new form based on that query (Form wizard > select your query).

Then make your new button display that form. Or use your new form as a subform on your main form.

Have you really properly read what Big Pat advised you? I have highlighted the buzz words.

 

[maks_prince]

Yah i got properly. I meant to say that the subform of the query should be displayed on the main form when i click display button. I hope you get what I mean. Check my attachments to see how i want it. I have created the form of the query.

 

[vbaInet]

Check my attachments to see how i want it.

Yes I had looked at your attachments before posting a reply.

I have created the form of the query.

Use this form as the Source Object of the subform located on the main form.

 

[maks_prince]

Thanks can u send me the codes which can be applicable to this...