Other options: Subform to display memo fields

[twoplustwo]

Hi guys, hope you're all well.

I have an unbound main form that users can search/filter etc. for company names. The sites then fill another list box. I need a decent way to display notes against the customer/sites. I'm playing around with a subform but it doesn't have the look I am after (the memo fields aren't displaying much of the text).

Any suggestions for a better approach?

Thanks.

 

[KenHigg]

Does a site have more than one memo record?

 

[twoplustwo]

Hi Ken, it certainly can.

 

[KenHigg]

Can you do a pop-up modal form that shows the data when you click the site in the list box?

 

[twoplustwo]

I presume Modal = Continuous? That's a good idea I presume you can't create a model subform?

 

[KenHigg]

Um... Never tried that, I'm guessing not.

You can do the continuous with form header and footer and make it look pretty good though...

 

[vbaInet]

If it's a listbox control, what you can do is get the value displayed in a texbox just below the listbox when a row is clicked. Just refer to the memo column in the listbox.

Me.TextboxName = Me.ListboxName.Column(x)

 

[KenHigg]

Or you could just pass the column(x) as an openarg to use as the filter for the modal form....