Related field on form

[whitestone]

Dear All

I am creating a form that is bound to the main table in my database.

However, I want to show one field from another table on the form that is linked to the main table (one-to-many relationship). I would do this using a sub-form but I also want the form to be a continuous form (as this has been asked form from on high) and Access won’t let me have a sub form if the main form is continuous.

Is there any other way that I can show the related field?

 

[le888]

Well, Access don't let you to have a continous mian form with a subform. The only way to do this is to create a pop-up form or simply another form. Which means that you create a continous main form and in the textbox of this form, create an event action to open an pop-up form or simply a form.

Mica

 

[Pat Hartman]

If your subform is in datasheet view, you can show the related table as a subdatasheet. The user will need to click the little + to open the subdatasheet. I've included a picture of one of my forms that uses this technique.